aspose file tools*
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
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Parameter Type Conflict: sqlType=2003" Watch "Parameter Type Conflict: sqlType=2003" New topic
Author

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



)

IS

orderstatus INTEGER (2) := 0;

workordernumber VARCHAR (9) :='w';



BEGIN


responseArr := workorderArr('');

FOR i in reqArr.first .. reqArr.last LOOP
-- SOS. PLEASE HELP ME!!!
dbms_output.put_line(workordernumber);



END LOOP;









END;



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(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterBytes(OracleCallableStatement.java:239)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:393)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:462)
at com.ceon.pencor.Test.main(Test.java:45)



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



 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Parameter Type Conflict: sqlType=2003