The JRun connection pooling mechanism is placing a proxy between your
program and the Oracle connection, there should be a method in the JRun API
that lets you get the 'real' connection from your variable conn, and then
you can do the Oracle specific stuff using that. You'll need to look in the
manuals or online docs to find the method name, sorry I don't know it off
the top of my head.
Cheers
Jay Walters
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 4:46 AM
To: JRun-Talk
Subject: Error While Using VARRAY
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
