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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
