Re: Truncate Table in a PL/SQL Block
From: Huijbrechts Rolf <huybrecr_at_realsoftware.be>
Date: 1996/10/25
Message-ID: <327125E1.48AB_at_realsoftware.be>#1/1
email : huybrecr_at_realsoftware.be or 101505.533_at_compuserve.com website: http://www.realsoftware.be/
Received on Fri Oct 25 1996 - 00:00:00 CEST
Date: 1996/10/25
Message-ID: <327125E1.48AB_at_realsoftware.be>#1/1
Brian M. Biggs wrote:
> I know in Oracle 7.1, and I think even in 7.2, the TRUNCATE command is a
> DDL command, and you have to use DBMS_SQL if you want to use it in
> PL/SQL.
The TRUNCATE command is a DDL command in Oracle V7.2 an V7.3 so you have
to use the plsql package DBMS_SQL.
Much appreciated,
Rolf Huijbrechts
REAL SOFTWARE
email : huybrecr_at_realsoftware.be or 101505.533_at_compuserve.com website: http://www.realsoftware.be/
Received on Fri Oct 25 1996 - 00:00:00 CEST