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


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 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.




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