Querying varray's contents from another session

  • From: "Peter Teoh" <htmldeveloper@xxxxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Jun 2008 11:39:20 +0800

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: