Java Function Fails With ORA-04063: index "SYS._NEXT_OBJECT" has errors (Doc ID 1272963.1)

Last updated on AUGUST 27, 2013

Applies to:

JDBC - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 27-Aug-2013***

Symptoms

When a java function calls a PLSQL procedure/function that uses XMLType.createXML(param_clob), it fails with following exception:

java.sql.SQLException: ORA-04063: index "SYS._NEXT_OBJECT" has errors
ORA-06512: at "SYS.XMLTYPE", line 5
ORA-06512: at "PROD.XXXXXXXXX_MGMT", line 914
ORA-06512: at line 1

Changes

Upgraded the driver from 10g to 11.2.0.1.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms