How to pass a collection to Stored Proc from Java

Ranch Hand

Posts: 31

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Jaydeep
Pass the collection of numeric id's as comma seperated one string, inside the procedure, enumerate the string.

Regards
MAkarand Parab

I will suppress my every urge. But not this shameless plug:

a bit of art, as a gift, that will fit in a stocking

https://gardener-gift.com