Re: Execute immediate

On 06 Feb 2003 11:01:18 GMT, Adrien <Adrien_at_nospam.com> wrote:

>
>Hello,
>
>If I execute a stored function in SQLPlus :
>
>variable a number;
>BEGIN
>:a := MyFunction ( NULL );
>END;
>/
>
>It works.
>
>But the same statement in an 'EXECUTE IMMEDIATE' statement in PL/SQL :
>
>EXECUTE IMMEDIATE 'variable a number; BEGIN :a := AlimGCE_CONT ( NULL );
>END;';
>
>doesn't work =>
>ORA-00900: invalid SQL statement
>
>Is it normal ?
>
>Thanks in advance.

Quite normal as VARIABLE is a *SQLPLUS* keyword, NOT a pl/sql keyword.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Feb 06 2003 - 23:26:39 CST