Execute immediate

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.

-- 
Ce message a ete poste via la plateforme Web club-Internet.fr
This message has been posted by the Web platform club-Internet.fr

http://forums.club-internet.fr/