Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> dbms_sql.parse Quesion

dbms_sql.parse Quesion

From: amogh <amogh.r_at_gmail.com>
Date: Thu, 06 Apr 2006 16:03:53 +0530
Message-ID: <op6Zf.25$nf4.55@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 ?

Rgds.
Amogh Received on Thu Apr 06 2006 - 05:33:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US