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

on 5/17/05 2:47 PM, Ranko Mosic at ranko.mosic_at_gmail.com wrote:

> Hi,
> I need to quickly create array; then browse it.
> I am thinking of using index by binary_integer type of collection because
> they don't need to be extended etc.
> How do I traverse this type of array (how does for ... loop look like )?
>
> Regards, Ranko.

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