Look at docs under "execute immediate' or dbms_sql package.
Good to tell us what version.
Jim
"Tom" <tptnll_at_yahoo.com> wrote in message
news:2e7bb509.0108310953.3ec4a8bd_at_posting.google.com...
> Hi:
> I have a pl/sql procedure that needs to be able to call any one of
> many other procedures. The names of these procedures are carried in a
> table, and depending on the current circumstance, the appropriate
> procedure name is selected and then executed. Is there a way to
> dynamically execute these procedures?
>
> The psuedo looks like this:
>
> CREATE OR REPLACE PROCEDURE pr_tom(an_circumstance number,
> otherarguements)
> AS
> BEGIN
> select procedure_name
> into variable
> from table
> where circumstance := an_circumstance;
>
> /* Logically, this is what I want to do
> ******************************
>
> execute variable(otherarguements) /* the arguement list is always the
> same */
>
> *********************************** Can this be done? */
>
> END pr_tom;
>
>
> Thanks in advance
Received on Fri Aug 31 2001 - 13:32:30 CDT
