Hi everyone!
I am trying to call an Oracle stored procedure (PL/SQL) form Java program using JDBC and return object
or object array. The problem I have is how to make Java to recognize the object that Oracle is sending
back. During runtime I'm getting similar to this messages:
Exception in thread "main" java.sql.SQLException: Parameter Type Conflict:
sqlType=2003
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java)
at ArrayEx.main(ArrayEx.java:57)
Has anyone used stored procedures in Java?
I would appreciate any ideas or samples.
TIA
KingTod