java.sql.SQLException: ORA-01722: invalid number

From: Skinny Chinese Guy <skinnychineseguy_at_yahoo.com>
Date: 27 Sep 2001 12:31:19 -0700
Message-ID: <95f0ce59.0109271131.564e308b@posting.google.com>

Hi,

I know this can happen when you try to convert from a string to a number but is there any other case where this exception can happen? I'm INSERTing into a table with columns of NUMBER, VARCHAR2, and DATE and very certain that I'm putting in the proper types. But saw this exception happen before. Haven't been able to reproduce it, but can't figure out why the heck it happend on the INSERT.

Is there any other weird case that one gets this exception, or some other situation where you get this exception but its misleading? Thanks. Received on Thu Sep 27 2001 - 14:31:19 CDT