Re: JDBC error feedback like in SQL*Plus

From: Mark Bole <makbo_at_pacbell.net>
Date: Sun, 12 Sep 2004 01:53:08 GMT
Message-ID: <8_N0d.18502$163.17705@newssvr27.news.prodigy.com>

Angus wrote:

> JDBC question wrote:
> 

>>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')
>>

[...]

> But in any case, your example error "ORA-12541: TNS:no listener"
> has nothing at all to do with an SQL statement.[...]
> 
> Good Luck,
> Avi.

The error has everything to do with the SQL statement -- the reference to the DB link failed to resolve. The error is coming from the client, not the server.

--Mark Bole Received on Sat Sep 11 2004 - 20:53:08 CDT