Home » RDBMS Server » Server Administration » EXECUTE IMMEDIATE got PLS-00103 error.
EXECUTE IMMEDIATE got PLS-00103 error. [message #370564] Tue, 21 December 1999 06:27 Go to next message
Jerry
Messages: 21
Registered: December 1999
Junior Member
When I start modify.sql:

CREATE OR REPLACE PROCEDURE ModifyField
IS
BEGIN
EXECUTE IMMEDIATE ¡¯CREATE TABLE bonus (id NUMBER, amt NUMBER)¡¯;
END;
/

It show the errors:
Errors for PROCEDURE MODIFYFIELD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4/11 PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one
of the following:
:= . ( @ % ;
But I can't see any errors in it!
Re: EXECUTE IMMEDIATE got PLS-00103 error. [message #370692 is a reply to message #370564] Wed, 19 January 2000 23:46 Go to previous message
Nanduri V Rao
Messages: 13
Registered: January 2000
Junior Member
Execute Immediate is Oracle 8i command and I have personally tested and found that it works perfectly.

Please check if you are working with an earlier version.
Previous Topic: Column Level Security
Next Topic: How can I open multiple database ....??
Goto Forum:
  


Current Time: Tue Oct 20 09:50:25 CDT 2020