Using setArray method for passing parameters to PL/SQL

From: <sjeevan_at_my-deja.com>
Date: Tue, 11 Jan 2000 10:41:03 GMT
Message-ID: <85f1bu$r7a$1@nnrp1.deja.com>

While trying to execute a Oracle PL/SQL from Java code (jdk1.2.2) I am facing a problem. The input and output parameters to the PL/SQL are of type array. I could not use the setArray method from CallableStatement for passing the in parameters.

The setArray method takes the parameters int and Array (which is an interface in java.sql package).

I am using JDBC 2.0 and Oracle thin connection.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 11 2000 - 04:41:03 CST