Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is this possible with "execute immediate"

Re: Is this possible with "execute immediate"

From: Jeremy <jeremy0505_at_gmail.com>
Date: Wed, 26 Apr 2006 15:55:35 +0100
Message-ID: <MPG.1eb99a44ddb6a35b98a198@news.individual.net>


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.

-- 

jeremy
Received on Wed Apr 26 2006 - 09:55:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US