Re: Truncate Table in a PL/SQL Block
From: Huijbrechts Rolf <huybrecr_at_realsoftware.be>
Date: 1996/10/23
Message-ID: <326E7796.3CBF_at_realsoftware.be>#1/1
email : huybrecr_at_realsoftware.be or 101505.533_at_compuserve.com website: http://www.realsoftware.be/
Received on Wed Oct 23 1996 - 00:00:00 CEST
Date: 1996/10/23
Message-ID: <326E7796.3CBF_at_realsoftware.be>#1/1
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.
Hi,
I would like to thank you all for your solutions.
Much appreciated,
Rolf Huijbrechts
REAL SOFTWARE
All opinions expressed are mine and not those of my employer.
email : huybrecr_at_realsoftware.be or 101505.533_at_compuserve.com website: http://www.realsoftware.be/
Received on Wed Oct 23 1996 - 00:00:00 CEST
