Exporting Plsql Package-defined type to JAVA
307173Jan 26 2005 — edited Jan 28 2005Help!
I am trying to get a descriptor for the type RECORDTYPE define in a PLSQL package (PKGE).
------------my pkge
create or replace package pkge
..
type recordType is record {
id number(10,0),
name varchar260),
};
...
-----------my java code
...
// Create the StructDescriptor from the connection
StructDescriptor rowStructDesc = StructDescriptor.createDescriptor("USR.PKGE.RECORDTYPE", con);
...
-----------I have the following error:
Exception occured : java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01460: unimplemented or unreasonable conversion requested ORA-06512: at "SYS.DBMS_PICKLER", line 18 ORA-06512: at "SYS.DBMS_PICKLER", line 58 ORA-06512: at line 1
-------------- Question?
Is there a way to make it work. (Not creating object type)