Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error when trying to truncate table from within PL/SQL

Christine1111Apr 12 2007 — edited Apr 12 2007
Hello.....

Does anyone know why I get an error when trying to execute the following command from within PL/SQL?

truncate table event;

The error is as follows:
ORA-06550: line 20, column 14:
PLS-00103: Encountered the symbol "TABLE" when expecting one of the following:

:= . ( @ % ;
The symbol ":= was inserted before "TABLE" to continue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2007
Added on Apr 12 2007
3 comments
965 views