Inconsistent catalog view

From: Frederic Houbie <fh_at_ionicsoftDELETEME.com>
Date: Wed, 12 May 2004 11:50:07 +0200
Message-ID: <40a1f350$0$8981$6c56d894@feed0.news.be.easynet.net>

I get

java.sql.SQLException: Internal Error: Inconsistent catalog view

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)

         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

         at
oracle.sql.StructDescriptor.initMetaData1_9_0(StructDescriptor.java:2095)

         at
oracle.sql.StructDescriptor.initMetaData1(StructDescriptor.java:2034)

         at
oracle.sql.StructDescriptor.isInstantiable(StructDescriptor.java:1212)

         at oracle.sql.STRUCT.<init>(STRUCT.java:142)
         at oracle.sql.OracleSQLOutput.getSTRUCT(OracleSQLOutput.java:137)
         at oracle.sql.STRUCT.toSTRUCT(STRUCT.java:771)
         at 
oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8874)
         at 
oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9202)
	at 

oracle.jdbc.driver.OracleCallableStatement.setObject(OracleCallableStatement.java:5416)

when doing a setObject on a

CallableStatement cs = conn.prepareCall("{ call SaveObject(?)}"); cs.setObject(1, ro);

ro is an object of type SERV that exists in a schema A, the java code is executed by user B and I made a GRANT ALL ON A TO B procedure SaveObject is created in B schema.

I've read it may be rights permission, but even if user B has DBA role, it doesn't work.

Ideas are welcome

Fred Received on Wed May 12 2004 - 04:50:07 CDT