Re: PL/SQL Function Calls

Billy wrote:
> Chris ( Val ) wrote:
>
> > Well, if "ProcName" is a varchar2 type for example,
> > then it only makes sense to use the following call:
> >
> > exec test( 'Procedure(''Argument'')' );
>
> EXEC command is a SQL*Plus macro command and not a valid SQL or PL/SQL
> command.

Sorry - I thought the OP wanted to know how to execute the procedure from within an SQL*PLUS session.

> Using literals and not bind variables is a great way to stuff up
> performance, cause shared pool fragmentation and generally cause havoc
> in Oracle.

Sure, but that was not my intent - I just think I missunderstood the question.

Thanks for your help.
Chris Val Received on Mon Jun 06 2005 - 19:12:51 CDT