• Post Reply Bookmark Topic Watch Topic
  • New Topic

TABLE type as IN / OUT in a Stored Procedure

 
L Goundalkar
Ranch Hand
Posts: 395
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have a stored procedure which takes TABLE type of variable as IN parameter. How Can I set a interget type array to this Stored Procedure as IN paramter using setters available in CallableStatement interface.?
Also please let me know how can I get OUT parameter which is defined as TABLE type in PL/SQL.
Thanks for the time.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
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!