SQL*Loader Reports ORA-1722: "INVALID NUMBER" For Wrong Column
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
This document will show that it is possible for SQL*LOADER to report an error ORA-1722 on a simple data set that contains an invalid number. The error message as such is correct but we will show that it is possible to see the error being reported on the wrong column.
The following steps should only be done on a TEST database if wished to see first hand as it requires change of a database parameter and we also need to stop/start the database a number of times.
The data, tables and SQL*LOADER controlfile are defined as follows:
File 'data.txt' containing the data to be loaded:
SQL script 'tables.sql' for creating the table:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms