Hi,
I want to create a Oracle ARRAY passed to the oracle stored procedure, which will return me the result.
If I directly create connection as follows:
String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
......
....
connection = DriverManager.getConnection(url, username, password);
Then I use this connection to create ArrayDescriptor instance as follows, no problem.
oracle.sql.ArrayDescriptor arraydesc
= oracle.sql.ArrayDescriptor.createDescriptor("FIELDIDARRAY", connection);
oracle.sql.ARRAY oracleArray = new ARRAY(arraydesc, connection, elements);
But I retrieve the connection from weblogic server DataSource configed using the exactly same parameter, but cannot create oracle ArrayDescriptor
and oracle.sql.ARRAY instances, I got following errors:
Fail to construct descriptor: Unable to resolve type: "UUM.FIELDIDARRAY"
where UUM is database schema name. I checked the database, we have FIELDIDARRAY object defined in Oracle under this schema.
Would someone help me out about this issue?
[ October 22, 2004: Message edited by: hongwei wang ]