How to specify truncate table statement in PL/SQL block

[request]

I have a PL/SQL block where I am specifying

truncate table table_name.

However, it gives an error for this statement.

How do you specify truncate statement in PL/SQL???

Thanks.

 

[THoey]

I had to do the following in a stored procedure:

sql_trunc := 'TRUNCATE TABLE EHGRIFF.C_AGENT';
EXECUTE IMMEDIATE sql_trunc;

Does that help? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[JunkYardDog]

in a standalone block put the truncate statement before the declare section