Re: Truncate Table in a PL/SQL Block

On 24 Oct 96 01:29:48 -0700,

         Robert Desatnik wrote:
>Have you tried using built-in package DBMS_SQL to accomplish this?
>Since it is not possible to use DDL in a PL/SQL block, this is a way
>of getting around the restriction. Look in the PL/SQL User's Guide
>for information on this procedure. Hope this helps.

doesn't the SQL statement :

truncate table <name>

work? and you don't need DBMS_SQL to do it?

check 7.3 SQL Reference Manual (page 4-455)

if you wanted to "drop" a table, you have to use DBMS_SQL

Brgds,

--M. Received on Fri Oct 25 1996 - 00:00:00 CEST