Re: how do you call procedures dynamically

Simon Spencer wrote:
>
> I am looking for a way to call a procedure dynamically (ie, not knowing
> the name of the procedure at compile time). I have tried quite a few
> methods but without any luck, I believe that the DBMS_SQL package should
> allow me to achieve my goal, but I am stuffed if i know how to get it to
> work.
> -----------------------------------------------------------------------
> Simon Spencer
> Vice President Work: 203-961-6140
> IPD, Operations and Technology Fax: 203-961-6163
> Emerging Technologies Group Cell:
> 100 First Stamford Place Email: simon.spencer_at_citicorp.com
> 7th Floor, Stamford CT.
> 06902 USA
> ----------------------------------------------------------------------DBMS_SQL string has to be a valid PL/SQL block:

begin
...
sSQL:= 'begin; theProcedureIWantToCall; end;'; DBMS_SQL.PARSE (handle1, sSQL, DBMS_SQL.V7); ...
end;

take a look in "Application Developers Guide' v7.2, chapter 11

-- 
____________________________________
Oleg Dimerman (olegd_at_e-mail.com)