Re: dbms_sql.parse Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 07 Apr 2006 20:47:36 +0200
Message-ID: <ascd32tssitr0g9q6p05isl74ci030ff6f@4ax.com>

On Fri, 07 Apr 2006 19:10:21 +0530, amogh <amogh.r_at_gmail.com> wrote:

>I would want to just parse it if I'm writing an application
>to parse user inputed DDLs and add them to a SQL script.
>I would'nt want to add incorrect DDLS into the script. Right
>now I will have to drop each of these objects since they
>would be created by the parse procedure.
>
>I feel this is a valid ne

Incorrect DDLs are trapped by proper error trapping. Also end-users should NOT (I repeat NOT) be allowed to run DDL.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Apr 07 2006 - 13:47:36 CDT