Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC equivalent mapping of IN OUT nocopy parameter in oracle

 
Sumitha Venkatachalapathi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If the stored procedure in oracle is as below

PROCEDURE test_inout( x_test IN OUT NOCOPY test_inout_tbl,
status OUT NOCOPY VARCHAR2,
msg OUT NOCOPY VARCHAR2,
run_id IN NUMBER)

where test_inout_tbl is of type test_inout_obj

test_inout_obj IS OBJECT
(
serial_num VARCHAR2(40),
return_status VARCHAR2(40),
output test_inout_dtl
)

where test_inout_dtl is of type test_inout_dtl_obj
test_inout_dtl_obj IS OBJECT
(
org_cd VARCHAR2(40),
org_name VARCHAR2(40),
org location VARCHAR2(40)
)

To the above stored procedure serial_num should be passed as an input and test_inout_dtl should be the output

Could you please let me know how the inputs for this can be provided from java jdbc?

Am currently using jdk 1.7

Thanks in advance

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic