Re: Parsing SQL-statement before executing?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 21 Jul 1999 21:36:42 +0800
Message-ID: <3795CCEA.4850@yahoo.com>

Magnus Rosenquist 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

You could always append "and rownum < 0" on them and run them as they are entered...you get no rows if they work, and an oracle error if they dont...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 21 1999 - 08:36:42 CDT