Re: JDBC error feedback like in SQL*Plus

From: JDBC question <medvedevclasses_at_yahoo.com>
Date: 10 Sep 2004 11:26:48 -0700
Message-ID: <981289bf.0409101026.298b2e6f@posting.google.com>

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)? Received on Fri Sep 10 2004 - 13:26:48 CDT