Re: JDBC error feedback like in SQL*Plus

JDBC question wrote on 10.09.2004 20:26:
> Thanks for the reply! I wonder if there was pure JDBC way...
> or even using Oracle-specific jdbc classes for that?
>
> To give a better SQL example: by running this query:
> SQL> select stuff from dual;
> select stuff from dual
> *
> ERROR at line 1:
> ORA-00904: "STUFF": invalid identifier
>
> That's the kind of output I am trying to get back. After
> all, it's the same Oracle server code that's parsing the query,
> so why it's returning less information through JDBC
> compared to OCI (e.g. oerhms function)?

This depends on the JDBC driver version. I think starting with the 9.2 drivers Oracle has added this information to the error message supplied in the Exception

Thomas Received on Fri Sep 10 2004 - 15:06:25 CDT