Re: Truncate table call in procedure

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 21 Jan 2000 21:18:25 -0000
Message-ID: <948489909.26311.2.nnrp-07.9e984b29@news.demon.co.uk>

It isn't, you could use

dbms_utility.exec_ddl_statement('string');

Nevertheless native dynamic DDL is not
allowed in pl/sql pre 8.1 - there have to be some limitations or Oracle couldn't keep on finding reasons to upgrade ;)

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Ron Lamb wrote in message
<86acce$dmb$1_at_ssauraac-i-1.production.compuserve.com>...
>Thanks for all the replies I have gotten.
>
>Why DBMS_SQL was needed for such a simple statement is
>beyond me, but I have made the changes and it worked.
>
>Ron
>
>
Received on Fri Jan 21 2000 - 15:18:25 CST