Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Function Calls
Thanks for quick reply!
How could I use this method if I had to pass parameters IN and OUT?
TIA! On Mon, 06 Jun 2005 13:35:15 +0200, Cris Carampa <cris119_at_operamail.com> wrote:
>Bullseye wrote:
>
>> PROCEDURE test (ProcName) IS
>> BEGIN
>> DECLARE
>>
>> BEGIN
>> << do something>>
>>
>> < Execute Procedure 'ProcName' as passed in Arguments >>;
>
>execute immediate 'begin '||ProcName||'; end;' ;
>
>>
>> << do something else
>> END;
>> END;
>
>Kind regards,
Received on Mon Jun 06 2005 - 07:06:46 CDT