• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Tim Moores
  • Carey Brown
  • Mikalai Zaikin
Bartenders:
  • Lou Hamers
  • Piet Souris
  • Frits Walraven

Parameter Type Conflict: sqlType=2003

 
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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



 
Mo-om! You're embarassing me! Can you just read a tiny ad like a normal person?
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic