Hi All,
I have a Oracle Stored procedure which will return VARRAY.
I am using following script to get the value in to an array.
Connection conn=getDBConn();
ArrayDescriptor ardesc=ArrayDescriptor.createDescriptor(
"css_config.tst_varray",conn);
OracleCallableStatement ocs =
(OracleCallableStatement)conn.prepareCall("begin f_test_varray(?);end;");
ocs.registerOutParameter
(1, OracleTypes.ARRAY,"tst_varray"); //tst_varray name of the variable
of type VARRAY.
ocs.execute();
oracle.sql.ARRAY array = ocs.getARRAY(1);
But at runtime this is giving me
java.lang.ClassCastException: allaire.jrun.sql.ConnectionProxy
Could anybody help me to fix this problem?
Thanks in Advance
Savant
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
