decimal("|",0)

Hi all

We are running 10.2.0.3 and recently I have renamed a table

(alter table owner.table rename newname)

After that my app team tried to load the table under its new name via Ab initio. They got the following error

Failed to generate control file

Oracle sqlldr cannot handle implicit delimited decimal strings.

Please change your input field acct_key which is of type decimal("|", 0)

to a fixed-width or explicit decimal point type or floating decimal point type.

Example:

Reformat a decimal(",",2) to: decimal(4,2) or decimal(4.2) or decimal(4)

After that they compared the load script against production (where the table has not been renamed) and dev (where the table has been renamed) and found the following difference: