This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Parameter Type Conflict: sqlType=2003 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Parameter Type Conflict: sqlType=2003" Watch "Parameter Type Conflict: sqlType=2003" New topic

Parameter Type Conflict: sqlType=2003

nandini lagunia
Ranch Hand

Joined: May 05, 2009
Posts: 57
I am using Oracle 9i and jdk 1.4.
I have written a stored procedure that takes Array and returns Array.

For that I've crteated a type like as follows:-
CREATE TYPE workorderArr AS varray(100) OF varchar2(100);

My stored procedure looks like:-

CREATE OR REPLACE PROCEDURE delcust_order_byworkorder_mul (

reqArr IN workorderArr,

responseArr OUT workorderArr



orderstatus INTEGER (2) := 0;

workordernumber VARCHAR (9) :='w';


responseArr := workorderArr('');

FOR i in reqArr.first .. reqArr.last LOOP



Now I am trying to execute this Stored procedure through my java code as follows:-

This program compiles fine but upon running, it gives me following exception:-

java.sql.SQLException: Parameter Type Conflict: sqlType=2003
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterBytes(
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(
at com.ceon.pencor.Test.main(

I don't have any clue what's wrong with the code.
Any kind of help will be highly appreciated.

I agree. Here's the link:
subject: Parameter Type Conflict: sqlType=2003
It's not a secret anymore!