Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC equivalent mapping of IN OUT nocopy parameter in oracle  RSS feed

 
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
Boost this thread!