JDBC error feedback like in SQL*Plus

From: JDBC question <medvedevclasses_at_yahoo.com>
Date: 9 Sep 2004 11:21:10 -0700
Message-ID: <981289bf.0409091021.2ebd6b24@posting.google.com>

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_at_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! Received on Thu Sep 09 2004 - 13:21:10 CDT