Re: TRUNCATE TABLE from PL/SQL?
Date: 1997/03/10
Message-ID: <332356ab.9203676_at_netnews.worldnet.att.net>#1/1
Petter,
>Is there a way to do a truncate table from within a stored procedure?
Yes. And If was at the office I could include an example. I just recently wrote a stored function to do grants and revokes. Look in the Application Developers Manual under "Dynamic SQL". Oracle 7 includes a package that will let you execute built up SQL statements, including DDL, from pl/sql. One of the functions in the package is "parse" and it should do what you want.
Email me monday if you havn't figured it out by then. I will be in the office monday evening (Michigan time) and can email you a sample.
Hope this helps. Sorry I just can't remember the exact details right now.
Jonathan Gennick
gennick_at_worldnet.att.net "Brighten the Corner Where you Are"
Received on Mon Mar 10 1997 - 00:00:00 CET