Is the list so large it exceeds the allowed statement size for Oracle? George Sexton MH Software, Inc. http://www.mhsoftware.com/ Voice: 303 438 9585
> -----Original Message----- > From: Norris Shelton [mailto:[EMAIL PROTECTED] > Sent: Monday, February 28, 2005 8:43 AM > To: [email protected] > Subject: [dbutils] Sending large set of numbers > > I have the following query > SELECT * > FROM foo_vw > WHERE sid IN > (1302352, > ..., > 1302359) > > > I am getting the following java.sql.SQLException: ORA-01722: > invalid number > > ===== > > Norris Shelton > Software Engineer > Sun Certified Java 1.1 Programmer > Appriss, Inc. > ICQ# 26487421 > AIM NorrisEShelton > YIM norrisshelton > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - 250MB free storage. Do more. Manage less. > http://info.mail.yahoo.com/mail_250 > > --------------------------------------------------------------------- > 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]
