Re: Call a stored procedure in DBMS_SQL

Create the dynamic statement as follows:

'begin my_proc(a,b,c); end;'

'select my_func(e,f) from dual'

in the second case make sure that the function does not modify the db. This will result in an error. For functions the following has to be defined:

PRAGMA RESTRICT_REFERENCES (my_func, WNDS,WNPS,RNDS,RNPS);

Bye,

Michael

Bigfoot wrote:

> Hi,
>
> Is it possible to execute a Stored Procedure or a function
> through Dynamic SQL.
> If so can someone give me an example.
> Only during the run time I will know what is the stored program to
> execute so I need to use the DBMS_SQL facility,
>
> Thanks
> Pushparaj
Received on Tue Apr 10 2001 - 07:11:53 CEST