Re: nullifying all variables in a package

Try dbms_session.reset_package. This call will reset all packages variables to their defaults (and will close and flush all cached cursors and free other resources, too, but it will not reset system contexts and it will not cause package initialization part to be re-executed when package is next accessed). Note that no explicit default for a package variable defaults it to NULL.

--
Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Kamal" <kamal80_at_virgilio.it> wrote in message
news:4e766a02.0301220748.3ab640d8_at_posting.google.com...


> Hi everybody there.


>

> First thing: am I writing to the right newsgroup? Is there a specific

> newsgroup for PL/SQL?

>

>

> Then:

>

> Does anyone know how to nullify all the variables in a package without

> having to write:

>

> v1 := null;

> v2 := null;

> ...

> vn := null;

>

>

> If I could have the list of all the variables in the package (even

> just the global ones) without knowing them before I could do:

>

> execute immediate 'begin package_name' || '.' || variable_name || ' :=

> null;

> end;';

>

> But: where can I find this list? Is there a clean straight way to

> build it?

>

> TIA

>

> Kamal