Fail to construct descriptor: Unable to resolve type
240037Dec 31 2003 — edited May 6 2004I'm receiving an error when creating a oracle.sql.STRUCT or ARRAY. the error is java.sql.SQLException: Fail to construct descriptor: Unable to resolve type "X.NAME".
He is the java code.
// Create the StructDescriptor from the connection
StructDescriptor prStructDesc =
StructDescriptor.createDescriptor("X.NAME", conn);
// construct the object array containing the attribute values for the
// X.NAME object to be inserted
Object[] xObjArray =
{
"val1",
"val2",
...
};
// Construct the Struct from the StructDescriptor and xObjStruct
oracle.sql.STRUCT xStruct = new STRUCT(prStructDesc,
conn, xObjArray);
cs = conn.prepareCall("{ call X.PROC(?,?,?)}");
cs.setObject(1, xStruct);
When I run the code within JDeveloper it runs without any errors. When I deploy to 9iAS release 2 and try to run it there, I receive the error. Thanks for any help.