This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Passing Array to Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Passing Array to Stored Procedure" Watch "Passing Array to Stored Procedure" New topic

Passing Array to Stored Procedure

Gilbert johnson
Ranch Hand

Joined: Jul 10, 2005
Posts: 45

I read the solution that AVI provided in the following topic:

But my error i still there.
I will try to provide you all the information. If you could help me, I would really appreciate it.

Oracle database version you are using
Oracle 9i

Java version you are using

JDBC driver

entire error message and stack trace you are getting

java.lang.ClassCastException: org.apache.commons.dbcp.PoolableConnection
at oracle.sql.ArrayDescriptor.createDescriptor(
at com.message.dao.MessageCenter.insertNewMessage(
at com.message.action.PopulateAction.execute(

the part of your java code that is causing the error

String[] str = {"MAST","MAST"};

//LINE 514
ArrayDescriptor desc = ArrayDescriptor.createDescriptor("PCKOMSMM100.CUST_NMBR_TABLE", con);

ARRAY newArray = new ARRAY(desc, con, str);
the call-spec for your PL/SQL procedure

It is part of a package PCKOMSMM100
Type CUST_NMBR_TABLE is table of VARCHAR2(30) ;

FUNCTION insertMessage (

subject: Passing Array to Stored Procedure
Similar Threads
how can I know my TNS Names_Entry?
Driver for jdk
struts deployment in weblogic 8.1
Array as input to stored procedure.
Passing array input in procedure - thin driver