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 -> Re: Parsing SQL-statement before executing?

Re: Parsing SQL-statement before executing?

From: <tedchyn_at_yahoo.com>
Date: Wed, 21 Jul 1999 14:40:47 GMT
Message-ID: <7n4m5d$tqe$1@nnrp1.deja.com>


In article <7n3s2k$mlm$1_at_vega.lejonet.se>,   "Magnus Rosenquist" <maro_at_gbg.ifsab.se> wrote:
> Hi !
>
> Anybody out there who knows if it's possible
> to parse a sql-statement before you execute it?
>
> I'm allowing the users to write their own statements from
> a client, the statement will then be executed in batch so
> any eventual errors will not be displayed until the batch is
> executed.
>
> Is there a way of parsing the statement by using some
> Oracle function and display the outcome to the user?
>
> Thankful for replies.
>
> regards,
> Magnus Rosenquist
>
>

Magnus, you can use stored procedure, function, package/package provided by oracle for that purpose. Ted Chyn

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 21 1999 - 09:40:47 CDT

Original text of this message

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