BS2000/OSD SQL*Loader-509 and Record n Rejected Invalid Packed Decimal Nibble
(Doc ID 947867.1)
Last updated on OCTOBER 09, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Fujitsu BS2000
Fujitsu Siemens BS2000/OSD
Symptoms
SQLLDR of Oracle Database 10g on BS2000/OSD has different behavior compared to SQLLDR of Oracle 9i. There are some special situations where you can not load input data which you have been able to load with Oracle 9i on BS2000/OSD:
1) When using a SAM or ISAM file with fixed record format (REC-FORM=(F,N) ) as input datafile SQLLDR aborts with:
SQL*Loader-500: Unable to open file (UPLOAD.F)
SQL*Loader-554: error opening file
SQL*Loader-509: System error: SOSD code 00000006 DMS=
2) If you want to load data of a binary datatype (RAW, DECIMAL etc.) and your input data contains a new line (X'15' in EBCDIC) SQLLDR aborts with:
Invalid packed decimal nibble.
Record 34: Rejected - Error on table TAB1, column COL1.
Value larger than specified precision allows for this column
Record 44: Rejected - Error on table TAB1, column COL1.
Invalid packed decimal nibble.
Changes
SQLLDR uses the generic behavior under BS2000/OSD now
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |