-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|