Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to know which line have syntax error via. JDBC interface?
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.comReceived on Mon Sep 26 2005 - 06:36:26 CDT