Re: Difference execute immediate within PL SQL

From: ovkrishna <>
Date: Thu, 16 Oct 2003 12:51:06 -0400
Message-ID: <>

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
Received on Thu Oct 16 2003 - 18:51:06 CEST

Original text of this message