Re: 'global' plsql table for access via several sessions

Hi Tom,

One option might be to pin the package in the library cache.. You can use the dbms_shared_pool package and the KEEP procedure within it to do this

SQL> EXECUTE DBMS_SHARED_POOL.KEEP('package_name');

To create the package you run the dbmspool.sql script.

Hope this helps,

Steve

In article <91v5ko$r78$1_at_nnrp1.deja.com>,   Thomas Schelhorn <tomsonn_at_my-deja.com> wrote:
> Hi everybody!
>
> I'm trying to do the following: in a package I declare a plsql-table
> (like the following code-snippet shows) and everything works fine in
> this session.
>
> declare
> type my_plsql_tabletype is table of my_table.my_column%type index
> by binary_integer;
> my_plsql_table my_plsql_tabletype;
>
> begin
> ... fill the table and use it
>
> But now my question - is there a way to keep one table in the
> cache/memory for several sessions (background: I want to prevent from
> creating ever and ever again the same table for every single session I
> start)
>
> thanx in advance
> Tom
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 22 2000 - 07:38:44 CST