Re: Is this possible with "execute immediate"

What i meant was something like:

create pacakge AAA is
  l_name util.array;
  procedure set_collection(p_name in util.array default util.empty_array);
  procedure form_1(); -- this is using l_name   procedure form_2(); -- this is also using l_name end AAA;
/

then you can call your procedures dynamically - you only need to set l_name beforehand. but of course i don't now if this is applicable in your situation ...

regs,
stephan Received on Wed Apr 26 2006 - 08:57:54 CDT