RE: Simplest way to create/use PLSQL collections

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman Sent: Tuesday, May 17, 2005 10:14 PM
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l