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
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,
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
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!