Re: dbms_sql.parse Question

From: amogh <amogh.r_at_gmail.com>
Date: Thu, 06 Apr 2006 16:32:43 +0530
Message-ID: <qQ6Zf.28$nf4.38@news.oracle.com>

Vladimir M. Zakharychev wrote:

> "amogh" <amogh.r_at_gmail.com> wrote in message news:op6Zf.25$nf4.55_at_news.oracle.com...
> 

>>Hi,
>>
>>From the PL/SQL packages doc:
>>
>>
>>>DBMS_SQL.PARSE Procedure
>>
>>>This procedure parses the given statement in the given cursor.
>>>All statements are parsed immediately. In addition, DDL
>>>statements are run immediately when parsed.
>>
>>Any reason as to why DDL statements are executed when passed
>>to DBMS_SQL.PARSE ?
>>

> 
> 
> Because that's the way DDL is processed in Oracle. As
> designed.

Right!!

But what do I do if I just want my DDL parsed and not executed ?

Rgds.
Amogh Received on Thu Apr 06 2006 - 06:02:43 CDT