Checking SQL syntax

From: ES <toto_at_titi.fr>
Date: Wed, 26 Mar 2003 17:07:25 +0100
Message-ID: <3e81cfff$0$29490$4d4eb98e@read.news.fr.uu.net>

Hello,

our application build an sql query with an intermedia clause : the user write the word list he is seeking and we build the where clause.

we need to allow the user to use the complete intermedia syntax, including near, fuzzy, ...
but when an error is writen by the user, we have a really bad reaction from oracle 8i (core dump, instance falling down)

does it exist a package that will test and agree a sql phrase without executing it ?

thanks Received on Wed Mar 26 2003 - 10:07:25 CST