RE: Arraylists/Collections

2004-06-24 Thread Satish Kataria
sday, June 24, 2004 9:07 PM To: '[EMAIL PROTECTED]' Subject: Arraylists/Collections 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

RE: [OT] Arraylists/Collections

2004-06-24 Thread Gaurav_Goyal
] 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

Re: Arraylists/Collections

2004-06-24 Thread Bill Siggelkow
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/Develope

Re: [OT] Arraylists/Collections

2004-06-24 Thread Kris Schneider
If by "proper", you mean "a standard approach that works for all JDBC-compliant drivers", I'm guessing you're out of luck. It will depend on your specific combination of driver and database. For example, to use an array as an IN param with Oracle I believe you have to use their ArrayDescriptor and

Arraylists/Collections

2004-06-24 Thread CRANFORD, CHRIS
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 Fairvie