Re: nullifying all variables in a package

Kamal wrote:

> 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

Probably c.d.o.server would be better but no one will be offended by continuing the discussion here.

There is no way to make null all variables in a package other than as you have indicated. But perhaps more importantly ... if there is a need to do [Quoted] [Quoted] this I would conclude that the package is poorly designed and/or written. Rather than trying to make every variable null ask why the design makes this necessary: It shouldn't.

Daniel Morgan Received on Mon Jan 20 2003 - 17:06:32 CET