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: How to know which line have syntax error via. JDBC interface?

Re: How to know which line have syntax error via. JDBC interface?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 26 Sep 2005 11:36:26 GMT
Message-Id: <pan.2005.09.26.11.36.26.619961@sbcglobal.net>


On Mon, 26 Sep 2005 00:20:10 -0700, AnySQL (d.c.b.a) wrote:

> When we have an syntax error in SQL issured in sqlplus, sqlplus will
> report which line caused this error, does any one know how sqlplus
> implement this feature, I think it's a servide feature, how I can
> report this error in my program, usually I can only run it and report
> the ORA- error code?

That's simple: put everything in a single line. That way, you'll know for sure in which line there was syntax error?

-- 
http://www.mgogala.com
Received on Mon Sep 26 2005 - 06:36:26 CDT

Original text of this message

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