Oracle DB Error ORA-08456 no sign in picture mask but SIGN clause in mask options

The following is the cause of this error message:

The picture mask parameter passed to a UTL_PG conversion routine contained no sign symbol ('S', '+', or '-'), but the mask options parameter contained a SIGN clause. A sign symbol is required in the picture mask parameter when the mask options parameter contains a SIGN clause.

Action you can take to resolve this issue: Correct the picture mask parameter or the mask options parameter.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related