Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is this possible with "execute immediate"
In article <1146059874.455302.171200_at_v46g2000cwv.googlegroups.com>,
steph says...
> 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 ...
>
This is probably me needing to do some more research here Steph because I don't undersatnd how we get from that to what I want... thanks for the pointers, appreciate the assistance.
-- jeremyReceived on Wed Apr 26 2006 - 09:55:35 CDT