Re: PL/SQL Function Calls

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.

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

--
Billy