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!

truncate table from procedure

576808Jun 15 2007 — edited Jun 15 2007

Hello,
Yes I have read the manual (truncate table)......found nothing

I get a compile error on a procedure that contains a "truncate table". Complete statement is "truncate table testit;" The error doesn't seem to make sense?

Error(47,12): PLS-00103: Encountered the symbol "TABLE" when expecting one of the following: := . ( @ % ; The symbol ":= was inserted before "TABLE" to continue.

Any Ideas? Is truncate not allowed in procedures?

Thanks,
Rick

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2007

Added on Jun 15 2007

9 comments

1,869 views