A possible way to do this could be to insert the collection into a temp table in the database and access that using the PL/SQL proc to do your processing.
-----Original Message----- From: Bill Siggelkow [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 11:14 AM To: [EMAIL PROTECTED] Subject: Re: Arraylists/Collections java.sql.Array? CRANFORD, CHRIS wrote: > Is there a proper way to pass an arraylist/collection to a pl/sql procedure > besides turning it into a string on the java-side and passing it then as a > VARCHAR parameter? > > _______________________________________________________ > Chris Cranford > Programmer/Developer > SETECH Inc. & Companies > 6302 Fairview Rd, Suite 201 > Charlotte, NC 28210 > Phone: (704) 362-9423, Fax: (704) 362-9409, Mobile: (704) 650-1042 > Email: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]