Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number Format in SQL*LOADER

231532Apr 8 2004 — edited Apr 23 2012

Hi:

Version of SQL*Loader : Release 9.2.0.4.0
Oracle DB version : 9.2.0.4.0

Data File

000001500-A
000000810-B
000000000 C
000012222 D

Control File

LOAD DATA
REPLACE INTO TABLE test1
(
FIELD1 POSITION (1:10) CHAR "TO_NUMBER(:FIELD1,'099999999MI')",
FIELD2 POSITION (11:11)
)

The first two records are loading but it is giving error from 3rd record. It is not accepting "blank" space as positive.
(Which it should because of the number format 099999999MI)

Please share your thoughts and experiences.

TIA.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2012

Added on Apr 8 2004

#database-key-features, #export-import-sql-loader-external-tables

2 comments

806 views