Start of change

-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

End of change