Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |