Re: Problem with TRUNCATE in PL/SQL?

From: Pei L. Ku <pku_at_gte.net>
Date: 20 May 1998 02:54:26 GMT
Message-ID: <6jtgl2$3e$1@gte2.gte.net>

TRUNCATE is not considered a normal DML -- PL/SQL only runs DMLs. If you want to run DDLs within PL/SQL blocks, you need to use DBMS_SQL package. See your PL/SQL book for details.

Pei
"I do Oracle DBA for a living -- but sometimes I'd rather work on my tack and jibe...."

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 - 21:54:26 CDT