Re: nullifying all variables in a package

From: Matthias Rogel <rogelREMOVE_at_THISweb.de>
Date: Thu, 23 Jan 2003 09:34:35 +0100
Message-ID: <b0o9er$rmmhs$1_at_ID-86071.news.dfncis.de>


hi kamal,

write a procedure
procedure nullifyallvariables;
within your package, that does what you want.

Or is it impossible to change the source?

matthias

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
Received on Thu Jan 23 2003 - 09:34:35 CET

Original text of this message