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!

Truncate table usage in procedure..

836881Feb 9 2011 — edited Feb 9 2011
Dears,

I created the table testing.

Now i wrote a procedure like this.

create or replace procedure trunc_test
(ov_v_output OUT VARCHAR2) IS
begin
truncate table testing;
end;

I got error message as

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

:= . ( @ % ;

Anybody help in this regard..

Thanks & Regards,
Raja.
This post has been answered by Karthick2003 on Feb 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2011
Added on Feb 9 2011
4 comments
98,936 views