Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews2.google.com!not-for-mail
From: medvedevclasses@yahoo.com (JDBC question)
Newsgroups: comp.lang.java.databases,comp.databases.oracle.server,comp.databases.oracle.misc
Subject: JDBC error feedback like in SQL*Plus
Date: 9 Sep 2004 11:21:10 -0700
Organization: http://groups.google.com
Lines: 20
Message-ID: <981289bf.0409091021.2ebd6b24@posting.google.com>
NNTP-Posting-Host: 63.202.82.212
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1094754070 2833 127.0.0.1 (9 Sep 2004 18:21:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 9 Sep 2004 18:21:10 +0000 (UTC)
Xref: dp-news.maxwell.syr.edu comp.lang.java.databases:50118 comp.databases.oracle.server:224601 comp.databases.oracle.misc:112552

Can one get full error text using JDBC similar to what SQL*Plus provides,
with the caret pointing to the column causing the problem?

E.g.:
ORA-12541: TNS:no listener

select decode(count(*),0,0,max(report_id)) from (select rg_reports.report_id
from RG.rg_reports@VIS1158 rg_reports
                   ^
where rg_reports.name = 'Rolling Income Statement')

I know you can get it back using OCI by calling the 
function oerhms (7.3) or OCIErrorGet (8.1.7).
But the most detail java returns in SQLException is:
ORA-12541: TNS:no listener

Anyone knows if it's possible to get the whole error text 
with the caret and all?

Thanks so much!