Getting a compilation error in procedures with TRUNCATE TABLE command (4303074)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting a compilation error in procedures with TRUNCATE TABLE command
Description

Get a compiler error when using "TRUNCATE TABLE tablename;". The same line executes within the standard editor.
Message is "[Error] Syntax check (33:22): Found: "TABLE" Expecting : ; -or- := -or- . -or- @ -or- (ROW."
Cause

TRUNCATE is a DDL command and cannot be run directly within pl/sql.
Resolution

Use
EXECUTE IMMEDIATE 'TRUNCATE TABLE tablename'
or
use DBMS_SQL.EXECUTE (see Oracle documentation for use of this package)

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title