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:


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?



Peter Teoh

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

Original text of this message