From: sminkeyk@interramp.com (Mark Sminkey)
Subject: Converting between Numbers
Date: 1996/02/22
Message-ID: <4giu92$jri@dlsn31.dal.mobil.com>#1/1
organization: MEPTEC - Mobil Oil Corporation
newsgroups: comp.databases.oracle


Question:

We have a table with a field defined as NUMBER(9,5).
We would like to load this data into another table with a field
defined as NUMBER(7,5).

e.g.  

TABLE X
----------------
....
FIELD1		NUMBER(9,5)

TABLE Y
---------------
....
FIELD1		NUMBER(7,5)

The following:

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.


Has anyone ever done something like this and if so how?

Thanks in advance.

Mark Sminkey
sminkeyk@interramp.com