PL/SQL : Truncate Table

               SQL> truncate table <table_name>

at the SQL prompt to delete the values from the table and automatically commit it.

Now I want to use the same command in PL/SQL block but it does not work.

It gives the following error.

        ORA-06550: line 4, column 12:
        PLS-00103: Encountered the symbol "TABLE" when expecting one of
the following:
        := . ( _at_ % ;

I know there is a package we use for the alternate of TRUNCATE TABLE command that
can be use in the PL/SQL block.

Kindly help me.

Thanks in advance.

Regards,
Salman Received on Sat Aug 07 1999 - 13:42:16 CEST