Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with TRUNCATE in PL/SQL?
The TRUNCATE command is a DDL command and not a DML command as is DELETE.
Therefore, from PL/SQL you will have to use the DBMS_SQL package.
--
Thomas W. Vanya
Database Administrator
Eastman Chemical Company
James Petts <jpetts_at_celltech.co.uk> wrote in article
<35618FB7.F1B6ACBB_at_celltech.co.uk>...
> Oracle 7.1.5.2.3, OpenVMS Alpha 6.1, PL/SQL 2.1.5.2.0
>
> Having problems TRUNCATING a table in another user's
> schema.
>
> TRUNCATE works fine in SQL*Plus.
> Can use 'DELETE FROM...' in PL/SQL OK.
> Owner of procedure has DELETE ANY TABLE
>
> Any ideas, anybody?
>
> James Petts
>
Received on Tue May 19 1998 - 15:02:15 CDT