Oracle database error code ORA-08456 – no sign in picture mask but SIGN clause in mask options

Oracle Database Error Code ORA-8456 Description :
no sign in picture mask but SIGN clause in mask options
Error Cause:
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.

How to Solve :
Correct the picture mask parameter or the mask options parameter.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»