File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to pass a collection to Stored Proc from Java

 
Jaydeep Deshmukh
Ranch Hand
Posts: 31
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Folks,

I need to pass a collection of numeric ids to a stored procedure in Oracle from a Java program. How do I achieve this?

Thanks in Advance
Jaydeep
 
Makarand Parab
Ranch Hand
Posts: 121
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Jaydeep
Pass the collection of numeric id's as comma seperated one string, inside the procedure, enumerate the string.

Regards
MAkarand Parab
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic