Re: verify SQL syntax without running it?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 28 Jul 2003 01:11:41 -0700
Message-ID: <92eeeff0.0307280011.7ae28d90@posting.google.com>

"Wayne" <invalid_at_invalid.invalid> wrote in message news:<jVFUa.23582$vx3.6287618_at_kent.svc.tds.net>...
> I'm using VB + ADO to access an Oracle back end. I'm writing an end-user
> query tool that builds and executes SQL. Is there a way I can check the SQL
> syntax against the RDBMS without actually returning a resultset?
>
> Thanks.

You may use dbms_sql package. Specifically look at dbms_sql.parse procedure. http://tahiti.oracle.com

Regards
/Rauf Sarwar Received on Mon Jul 28 2003 - 03:11:41 CDT