Truncate command in a procedure

I am attempting to create a procedure containing SQL truncate statements as in the following:

create procedure prep_database_sp
as
BEGIN truncate table ol_summary;
truncate table employee_appointment;
truncate table labor_distribution;
delete from employee;
delete from active_index;
delete from index_fund_xref;

END; This fails to compile with the truncate statement although the Oracle Handbook cites no restriction on the type of SQL statements that can be put in the body of a procedure.

I get the following error message:

PLS-00103 Encountered the symbol "TABLE" when expecting the one of the following: := . ( @ % ;

Is there anyway to use truncate or is this an 'undocumented feature'? Received on Fri Aug 20 1999 - 13:37:52 CDT