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