Re: Help with Temporary Tables

marcus johanson wrote in message
<01be8bd0$92dce0c0$ec1b1dac_at_ut9811251830>...
>incorporate the session_id in the name of the table...
>look it op in v$session.!!!!
>And ofcourse use the dbms_sql package to issue the 'create table command'
>
>/Jacob
>
>Paul Wiles <paul_at_adzi.com> schreef in artikel
><371c9771_at_newsread3.dircon.co.uk>...
>> please enlighten me!
>>
>> How do you create PL/SQL tables which reside only in memory and for
>duration
>> of a session and are unique for that session?
>>
>>
>> Frank van Bortel wrote in message <371C8AE9.717B92C6_at_vnl.nl>...

[snip]

Jacob, that is not a PL/SQL table. A PL/SQL table is a sparse table (aka "map" or "associative array", but with integer indexes only) held in memory, having completely different syntax and semantics from a database table.

Paul, each session's instance of package variables, including records and tables, are held in the session's PGA. The variables of a package are created when the session first references any of the package constructs (variables/cursors/procedures/functions). When the session disconnects, the package instance is no longer available.

Note that package instances are volatile; if a package is invalidated and recompiled, all package instances are lost.

PL/SQL tables are described in PL/SQL User's Guide and Reference (part of the documentation set).
Packages are descibed in Oracle Server Application Developer's Guide (part of the documentation set).

Regards,

Roy Brokvam
roy.brokvam_at_conax.com Received on Wed Apr 21 1999 - 07:59:10 CDT