Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parsing SQL-statement before executing?
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