Re: Help on oracle objects - Varrays with Preparedstatements - ArrayDescriptor problem

From: Vara <varaprasad_r_at_infosys.com>
Date: 18 Oct 2002 04:55:40 -0700
Message-ID: <dce6ff56.0210180355.6ea22b9a@posting.google.com>

Hi.

Thanks for the reply ... Could you help me with this:

Please find below the description of the problem:  

I am using PreparedStatements (mandatory as per project standards). The Oracle object I have is testobjtype and the package is testpkg. How do I register the outParameter of a varray type? I am getting error when I create a ArrayDescriptor ...  

Here is the code:  

OracleCallableStatement callableStatement = (OracleCallableStatement) con.prepareCall ("{ ? = call TESTPKG.testf(?)}");

callableStatement.setString(2, "test");

Object elements[] = new Object[20];

ArrayDescriptor desc = ArrayDescriptor.createDescriptor("TYPE_VARRAY", con);
/*
I tried with this also
ArrayDescriptor desc = ArrayDescriptor.createDescriptor("testobjtype", con);
*/

ARRAY newArray = new ARRAY(desc, con, elements);

callableStatement.registerOutParameter(1, OracleTypes.ARRAY, "newArray");

callableStatement.execute();

ResultSet rs = (ResultSet)callableStatement.getObject (1);

ERROR:
SQLException java.sql.SQLException: invalid name pattern: SYS.TYPE_VARRAY
java.sql.SQLException: invalid name pattern: SYS.TYPE_VARRAY

 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
 at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:424)
 at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:343)
 at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1002)
 at oracle.sql.ArrayDescriptor.<init>(ArrayDescriptor.java:132)
 at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:97)

 at com.busch.wms.interfaces.TestVarray.main(TestVarray.java:75)

Any suggestions/solutions would help me.

Vara Received on Fri Oct 18 2002 - 06:55:40 CDT