| ORA-17059 Cannot convert to internal representation [message #92726] |
Wed, 22 December 2004 23:31  |
Jan Tanis
Messages: 4
Registered: December 2004
|
Junior Member |
|
|
I'm getting this error as I try to execute the java code below:
private STRUCT getSelCritRecord(Connection conn, String STRINGVALUE)throws SQLException{
StructDescriptor rec_in_desc = StructDescriptor.createDescriptor("TEST_RECORD", conn);
Object[[]] objectValues = new Object[[]]{ new Integer(1),"Google"};
STRUCT struct = new STRUCT(rec_in_desc, conn, objectValues);
return struct;
}
private STRUCT getSelCritTable(Connection conn, STRUCT rec)throws SQLException{
StructDescriptor tab_in_desc = StructDescriptor.createDescriptor("TEST_TABLE", conn);
Object[[]] objectValues = new Object[[]]{ rec };
STRUCT struct = new STRUCT(tab_in_desc, conn, objectValues);
return struct;
}
I'm getting the stacktrace when the last STRUCT is made (STRUCT struct = new STRUCT(tab_in_desc, conn, objectValues);)
The rec variable is a STRUCT which was created in the function above it.
The typedeclaration of the two used types are:
CREATE OR REPLACE TYPE TEST_RECORD AS OBJECT
(
ID INTEGER,
STRINGVALUE VARCHAR2(255)
)
/
CREATE OR REPLACE TYPE TEST_TABLE AS TABLE OF TEST_RECORD
/
I've searched all FAQ's and forums for a solution but didnt ran into something valueable.
Thnx in advance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
