Hi
Receiving the following sql exception after executing a
jdbc prepared statement to retrieve all Index's that belong to a particular owner (see below). There are no index's in the schema and should return an empty result set, instead it points to an object that does not exist when I run the "select" statement from sql-plus command prompt - returns a message stating no index's within the schema.
Error Message:
INDEX=> BIN$k5756ypjQbW1+nVK39KJ3g==$0
java.sql.SQLException: ORA-31603: object "BIN$k5756ypjQbW1+nVK39KJ3g==$0" of type INDEX not found in schema "
TEST"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2805
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
JDBC Statement:
ps = conn.prepareStatement("SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE IN \'INDEX\' AND OWNER=?");