Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to pass a collection to Stored Proc from Java

 
Jaydeep Deshmukh
Ranch Hand
Posts: 31
  • 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
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic