OCI and other API's expose this, I could not find anything in JDBC (doesn't mean it is not there, just don't see it...)

However, you could call a stored procedure:


ops$tkyte@ORA9IR2> create or replace
2 function get_error_offset( p_query in varchar2 ) return number
3 authid current_user
4 as
5 l_theCursor integer default dbms_sql.open_cursor;
6 l_status integer;
7 begin
8 begin
9 dbms_sql.parse( l_theCursor, p_query, dbms_sql.native );
10 exception
11 when others then l_status := dbms_sql.last_error_position;
12 end;
13 dbms_sql.close_cursor( l_theCursor );
14 return l_status;
15 end;
16 /

Function created.

ops$tkyte@ORA9IR2> select *
2 from
3 testuser.emp22;
testuser.emp22
*
ERROR at line 3:
ORA-00942: table or view does not exist


ops$tkyte@ORA9IR2>
ops$tkyte@ORA9IR2> declare
2 n number;
3 str long := 'select *
4 from
5 testuser.emp22';
6 begin
7 n := get_error_offset( str );
8 dbms_output.put_line( substr( str, 1, n ) || '<<<<>>>>' || substr( str, n+1 ) );
9 end;
10 /
select *
from
testuser.<<<<>>>>emp22

PL/SQL procedure successfully completed.