Re: Difference execute immediate within PL SQL
From: ovkrishna <member44474_at_dbforums.com>
Date: Thu, 16 Oct 2003 12:51:06 -0400
Message-ID: <3489596.1066323066_at_dbforums.com>
Date: Thu, 16 Oct 2003 12:51:06 -0400
Message-ID: <3489596.1066323066_at_dbforums.com>
Truncate is a DDL statement and to use DDL statements within your Stored Porcedure, you either need to use DBMS_DDL (or is it DBMS_SQL) package.
You cannot execute them directly. That is the reason you are getting the compilation error.
-- Posted via http://dbforums.comReceived on Thu Oct 16 2003 - 18:51:06 CEST