OraFAQ Forum: SQL & PL/SQL » java.sql.SQLException: ORA-08103: object no longer exists

Home » SQL & PL/SQL » SQL & PL/SQL » java.sql.SQLException: ORA-08103: object no longer exists

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

java.sql.SQLException: ORA-08103: object no longer exists [message #125112]

Thu, 23 June 2005 06:32

rakeshprasad_uk
Messages: 1
Registered: June 2005

Junior Member

Hi,
Am calling this procedure from a java bean. In this call, the procedure gets executed successfully but when i try to access the RefCursor Object, I get an SQL Exception that the object no longer exists.

Here are some inputs for reference:

My DB Call:
cstmt = objConnection.prepareCall( "{ call CPPKG.fic_get_subcont_prog(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) }");

My RefCursor Access:
rsRuleSet = (ResultSet)cstmt.getObject(11);

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

Please note that the SQLException shown as per Java Stack trace is on the line with the RefCursor Access

If anybody has any idea, then do reply

Thanks in Advance,
Rakesh

Report message to a moderator

Re: java.sql.SQLException: ORA-08103: object no longer exists [message #125521 is a reply to message #125112]

Mon, 27 June 2005 04:09

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Looks like the object was deleted or recreated:

08103, 00000, "object no longer exists"
// *Cause:  the object has been deleted by another user since the operation
//          began
// *Action:

Try the following to look for objects that were recreated or changed:

SQL> SELECT owner, object_name,
  2         TO_CHAR(created, 'DD/Mon/YY HH24:MI') created,
  3         TO_CHAR(last_ddl_time, 'DD/Mon/YY HH24:MI') changed,
  4         status
  5    FROM dba_objects
  6   WHERE created > SYSDATE-1
  7      OR last_ddl_time > SYSDATE-1
  8  /

Best regards.

Frank

Report message to a moderator

Previous Topic:	Runnig .bat files from pl/sql procedures
Next Topic:	Outerjoin - Please help!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 06 05:21:14 CDT 2025