Re: Call a stored procedure in DBMS_SQL
Date: Tue, 10 Apr 2001 09:02:44 -0400
Message-ID: <9av09q$o4v1_at_biko.telecom.ups.com>
Thank you very much Michael.
Michael Zimmermann wrote in message <3AD29619.323DE915_at_vcs.de>... 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 - 15:02:44 CEST