Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Function Calls

Re: PL/SQL Function Calls

From: Bullseye <none>
Date: Mon, 06 Jun 2005 13:06:46 +0100
Message-ID: <21f8a1dd60updc2vihnq27uv3mbnu4ft42@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US