This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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

 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!