ORA-36338
(SNSYN128) invalid TO_NUMBER function syntax
Cause
The format of the TO_NUMBER function was incorrect.
Action
Correct the syntax and try again. The format of the TO_NUMBER function is TO_NUMBER(value [format] [{option optionvalue}...]). For more information, consult Oracle documentation.