RE: Simplest way to create/use PLSQL collections

  • From: "Post, Ethan" <Ethan.Post@xxxxxx>
  • To: <tim@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 18 May 2005 09:42:55 -0500

Tim,

I recall some bugs in 9i related to use of TEMPORARY tables that have me
in a "be careful" mindset, I would have to go back and find the bugs to
recall why I am thinking this but maybe someone else knows what I am
talking about.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Gorman
Sent: Tuesday, May 17, 2005 10:14 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Simplest way to create/use PLSQL collections

Ranko,

If your "browsing" has any degree of complexity, then instead of writing
extensive PL/SQL to "browse" arrays, why not create a GLOBAL TEMPORARY
table
and insert rows into it and "browse" them with SELECT statements?   You
can
set them up to clean themselves up after a COMMIT/ROLLBACK (i.e. end of
transaction) or when your database session disconnects.  A global
temporary
table is essentially an extension of a session's private memory.

Do away with all that PL/SQL code and do it in SQL instead?

Just my $0.02...

-Tim
--
//www.freelists.org/webpage/oracle-l

Other related posts: