Querying varray's contents from another session

From: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Tue, 10 Jun 2008 11:39:20 +0800
Message-ID: <804dabb00806092039g66f47049w1b29908c81ac9d04@mail.gmail.com>

I was looking at varray's programming in PL/SQL:

http://blogs.ittoolbox.com/database/solutions/archives/working-with-varrays-in-oracle-part-ii-9229

Now my question is: is it possible to query the data constructed inside this varray - of which the PL/SQL procedure is still running - from another session?

What is the internal implementation of varray like? Temporary tables ? How to enumerate all the varrays constructed by different sessions? And list their contents?

Thanks.

--

Regards,
Peter Teoh
--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 09 2008 - 22:39:20 CDT

This message: [ Message body ]
Next message: Nuno Souto: "Re: Certifications don't count! (from a good test-taker)"
Previous message: Dan Norris: "Re: Linux devices for ASM"
Next in thread: Gints Plivna: "Re: Querying varray's contents from another session"
Maybe reply: Peter Teoh: "Re: Querying varray's contents from another session"
Reply: Gints Plivna: "Re: Querying varray's contents from another session"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message