Oracle Object type not working in two schemas [message #191359] |
Tue, 05 September 2006 21:36  |
annijos
Messages: 2 Registered: September 2006
|
Junior Member |
|
|
Hi,
Our application has stored procedures which takes oracle object types (user defined) as in/out parameter.
now all these stored procedures works when we have only one schema with dba access rights. but if we create another schema lets say S2 (which has execute grant for all objects of S1)stored procedure stops working.....This is applicable only for the SPs with oracle object types....
any ideas? whats the issue?
|
|
|
|
|
Re: Oracle Object type not working in two schemas [message #191491 is a reply to message #191364] |
Wed, 06 September 2006 10:37   |
annijos
Messages: 2 Registered: September 2006
|
Junior Member |
|
|
here is what i have done.
1. Created type and stored procedure in S1
2. In second schema i created synonym and then i did
grant execute on <<object type>> <<SP>> to S2.
now if connect to database with S1, my jave program works and SP gets executed.....but if connect to database using S2....I get following exception
ERROR: Exception: java.sql.SQLException: Internal Error: Inconsistent catalog view
java.sql.SQLException: Internal Error: Inconsistent catalog view
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.sql.StructDescriptor.initMetaData1_9_0(StructDescriptor.java:1838)
at oracle.sql.StructDescriptor.initMetaData1(StructDescriptor.java:1782)
at oracle.sql.StructDescriptor.isInstantiable(StructDescriptor.java:1027)
at oracle.sql.STRUCT.<init>(STRUCT.java:126)
Please help.
- Shriram
|
|
|
|