Re: Converting between Numbers
From: Bill Manry <BManry_at_us.oracle.com>
Date: 1996/02/23
Message-ID: <4gl3c9$rrn_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1996/02/23
Message-ID: <4gl3c9$rrn_at_inet-nntp-gw-1.us.oracle.com>#1/1
sminkeyk_at_interramp.com (Mark Sminkey) wrote:
[...]
>INSERT INTO TABLE Y
>SELECT ...., TO_NUMBER(TO_CHAR(FIELD1,'99.99999'))
>FROM TABLE X;
>results in a ORA-01722 Invalid Number error after approxiamtely
>10,000 rows.
I would guess that you have a number greater than 99.99999 in tablex.
/b
-- Bill Manry - Mainframe & Integration Technologies - Oracle Corp. USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation.Received on Fri Feb 23 1996 - 00:00:00 CET