Oracle Error ORA-08499: Warning: picture mask options ‘string’ ignored by UTL_PG

Oracle Error Message

ORA-08499: Warning: picture mask options ‘string’ ignored by UTL_PG

Reason for the Error

Picture mask options such as OCCUR, SYNC and others are not processed by the UTL_PG numeric conversion routines.

Solution

This is an informational message only. The message may be eliminated by removing the unnecessary picture mask options from the parameter list passed to the UTL_PG routine.