Re: PL/SQL Function Calls

"Bullseye" <none> wrote in message news:21f8a1dd60updc2vihnq27uv3mbnu4ft42_at_4ax.com...
| Thanks for quick reply!

[Please post your response below the text to which you're replying, thanks. Reformatted below:

| 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,
|
|
| How could I use this method if I had to pass
| parameters IN and OUT?

Well, if "ProcName" is a varchar2 type for example, then it only makes sense to use the following call:

exec test( 'Procedure(''Argument'')' );

Cheers,
Chris Val Received on Mon Jun 06 2005 - 07:37:46 CDT