• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Junilu Lacar
  • Martin Vashko
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Scott Selikoff
  • salvin francis
  • Piet Souris

JDBC equivalent mapping of IN OUT nocopy parameter in oracle

 
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

 
You’ll find me in my office. I’ll probably be drinking. And reading this tiny ad.
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!