nullifying all variables in a package

[Quoted] 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 Wed Jan 22 2003 - 16:48:16 CET