Skip to Main Content

Oracle Database Discussions

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!

Getting compilation error when executing Truncate statement with Execute immediate in a PLSQL block.

DINESH EDVINFeb 20 2017 — edited Feb 20 2017

Hi,

I have compiled the below PLSQL block.

BEGIN

EXECUTE IMMEDIATE 'TRUNCATE TABLE TEST_TABLE';

END;

but it throwing the below error. I dont know why its coming.

ORA-06550: line 1, column 7:

PLS-00103: Encountered the symbol " " when expecting one of the following:

   ( begin case declare exit for goto if loop mod null pragma

   raise return select update while with <an identifier>

   <a double-quoted delimited-identifier> <a bind variable> <<

   continue close current delete fetch lock insert open rollback

   savepoint set sql execute commit forall merge pipe purge

The symbol " " was ignored.

This post has been answered by AndrewSayer on Feb 20 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2017
Added on Feb 20 2017
3 comments
669 views