-20476 THE function-name FUNCTION WAS INVOKED WITH AN INVALID FORMAT STRING format-string.
Explanation
An invalid format string was specified for the function-name function.
- function-name
- The name of the function. The value is either VARCHAR_FORMAT or DECFLOAT_FORMAT, even if the name used to invoke the function was TO_CHAR or TO_NUMBER.
- format-string
- The invalid format string.
A valid format string for the VARCHAR_FORMAT function
must:
- Have a data type length not greater than 254 bytes
- Contain only supported format elements.
- Not result in a string with an actual length that is greater than the length attribute of the result
A valid format string for the DECFLOAT_FORMAT function must:
- Have a data type length not greater than 254 bytes
- Contain at least one format element
- Contain only supported format elements.
System action
The statement cannot be processed.
User response
Change the format string argument of the function-name function.
SQLSTATE
22018
