OS Novell 4.2 Oracle
I have a table test desc as fld1 number(5,3), fld2 varchar2(1).
The control file has,(comma) delimited, optionally enclosed in " (quotes).
The data file contains 99.999,C
It fails with an ORA-01401: inserted value to large for column.
Question. Why did Oracle show an ORA-01401 when the problem is the "C" value was not
enclosed in quotes. I change the data to be 99.999,"C" and it loads properly.
I would have thought that it would display something to the effect that I was trying
to insert a non quoted value into a character field.
Any thoughts or ideas?
ROR mª¿ªm

Please see the official ORACLE-L FAQ: http://www.orafaq.com
Author: Ron Rogers
INET: RROGERS_at_galottery.org

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
postedAug 22, '01 at 12:35p
activeAug 22, '01 at 12:35p

1 user in discussion

Ron Rogers: 1 post



site design / logo © 2022 Grokbase