This discussion is archived
3 Replies Latest reply: Sep 13, 2013 8:34 AM by rp0428 RSS

how to register custom data type out parameters in callable statement

NR Explorer
Currently Being Moderated

HI

PL/SQL proc has an out parameter which is of custom datatype (table of varchar), and when i try to call pl/sql proc from java using oraclecallablestatement, we need to register it.

 

By using stmt.registerOutParameter(), and this method is only accepting param index and static values in Types.java. And if i use stmt.registerOutParameter(10,Types.ARRAY), its throwing an ORA-03115 exception.

 

Please throw me some light on how to register custom out params. Thanks.

 

N.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points