commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George Sexton" <gsex...@mhsoftware.com>
Subject RE: [dbutils] Sending large set of numbers
Date Mon, 28 Feb 2005 15:58:18 GMT
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:norrisshelton@yahoo.com] 
> Sent: Monday, February 28, 2005 8:43 AM
> To: commons-user@jakarta.apache.org
> 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: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message