commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Graham <grahamdavid1...@yahoo.com>
Subject Re: [dbutils] Sending large set of numbers
Date Mon, 28 Feb 2005 20:13:33 GMT
Possibilities I can think of:
1. SQL statement is too long
2. One of the entries isn't a number
3. Comma in the wrong place
4. The NUMBER column is too small for one of the numbers

David

--- Norris Shelton <norrisshelton@yahoo.com> wrote:

> 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 - You care about security. So do we. 
http://promotions.yahoo.com/new_mail

---------------------------------------------------------------------
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