Re: JDBC error feedback like in SQL*Plus

On Sun, 12 Sep 2004 01:51:01 GMT, Mark Bole <makbo_at_pacbell.net> wrote:

>As a side note, I spent a lot of time once trying to find *any* Oracle
>documentation (9i) on the "asterisk at the first character of the input
>related to the error" feature. Couldn't find any - maybe someone else
>has? I have noticed from time to time (sorry, no specific examples
>handy) that the asterisk is not always at the place where the error
>actually occurs.

 It can be retrieved in OCI with the OCI_ATTR_PARSE_ERROR_OFFSET statement handle attribute, although the following extremely brief mention is the only place I remember it being documented:

http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96584/ociaahan.htm#451631

 As you mention it doesn't always seem to get it spot on particularly on complicated statements; presumably due to quirks of how the Oracle parser works.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool