You'll have to give us the whole list, including the ..., if you want us
to be able to see the problem.

Feel free to send it to me privately.

Jennifer

------------------------------------------------------------------
Jennifer R. Amon              Phone: 440-962-2471
Lead Technical Consultant       FAX: 440-962-2663
Moen Incorporated             Email: [EMAIL PROTECTED]
25300 Al Moen Drive        Personal: [EMAIL PROTECTED]
North Olmsted, OH  44070   Web Site: http://home.comcast.net/~jenamon/
------------------------------------------------------------------
-----Original Message-----
From: Norris Shelton [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 28, 2005 10: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]


_______________________________________________
This message was scanned for viruses prior to entering the Moen network


_______________________________________________________________________

The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. Any 
review, retransmission, dissemination or other use of, or taking of any action 
in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact 
the sender and delete the material from any computer.
_______________________________________________________________________

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to