Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL: How to access tables globally.
>If you define the table in the package spec it will be accessible to
>everyone who has access to the package. If you define it globally in the
>package body it will only be accessible to the package members. In
>either case it will be persistent.
Just to be sure, and like Thomas wrote in his reply: they are *session* persistent. So when declared in the package specification, other packages indeed can see the data when being called from the very same session. However, even if declared in the package specification, two different sessions will have their own data in the PL/SQL table.
Arjan. Received on Sun Sep 06 1998 - 04:53:05 CDT