Ora-08103 Is Thrown When Program Calls "Callablestatement.Getobject(1)" To Retrieve The Cursor (Doc ID 1362699.1)

Last updated on MARCH 08, 2017

Applies to:

PL/SQL - Version 10.2.0.4 to 11.2.0.4 [Release 10.2 to 11.2]
JDBC - Version 10.2.0.4 to 11.2.0.4.0 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Jan-2014***

Symptoms


A Java application invokes a stored procedure that returns a cursor.
When the Java application tries to retrieve the ResultSet, an ORA-08103: object no longer exists is thrown.


CallableStatement callableStatement = c.prepareCall("begin stored_proc(?); end;");
callableStatement.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR);
callableStatement.execute();
ResultSet resultSet = (ResultSet) callableStatement.getObject(1);


java.sql.SQLException: ORA-08103: object no longer exists

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1074)
at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:369)
at oracle.jdbc.driver.OracleResultSetImpl.<init>(OracleResultSetImpl.java:74)
at oracle.jdbc.driver.T4CResultSetAccessor.getCursor(T4CResultSetAccessor.java:335)
at oracle.jdbc.driver.ResultSetAccessor.getObject(ResultSetAccessor.java:97)
at oracle.jdbc.driver.OracleCallableStatement.getObject(OracleCallableStatement.java:2028)
at oracle.jdbc.driver.OracleCallableStatementWrapper.getObject(OracleCallableStatementWrapper.java:651)

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