JR39098: ORA-01722 INVALID NUMBER ORACLE_ENTERPRISE_0,0: FATAL ERROR: APT_DECIMAL::ASSIGNFROMSTRING: INVALID FORMAT FOR THE SOURCE STR

APAR status

• Closed as Permanent restriction.

Error description

• I (1) set NLS_LANG=ITALIAN_ITALY.WE8ISO8859P15, (2)
  NLS_NUMERIC_CHARACTERS=,.  (3) removed the NLS_NUMERIC
  hard-coded variable and a reading/writing Oracle EE job failed
  with this error message:
  Oracle_Enterprise_0,0: Fatal Error:
  APT_Decimal::assignFromString: invalid format for the source
  string.
  
  So I modified the Job parameters to work with "," like this:
  And that fixed it.
  The Oracle EE job successfully reads and writes numeric data
  without the hard-coded numeric_characters env var.
  

Local fix

Problem summary

• Oracle Enterprise stage is hard-coding
  Oracle's NLS_NUMERIC_CHARACTERS environment variable and this is
  causing some Oracle views to fail execution because they rely
  on decimal separators other than the period.
  

Problem conclusion

• In 753 the Parallel Framework only has support for the period
  decimal seperator, so the Oracle EE stage must notify Oracle
  that it must recieve/send all decimal numbers with a period for
  the decimal seperator. If the DataStage Job property with the
  decimal seperator is modified on 753 and earlier, the Parallel
  framework will ignore this setting. For versions 801 and later,
  this is not an issue and DataStage is working correctly.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels