ORA-08456: no sign in picture mask but SIGN clause in mask
options



ORA-08456: no sign in picture mask but SIGN clause in mask options..

Answer / guest

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.

Action: Correct the picture mask parameter or the mask
options parameter.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08005: specified row does not exist

1 Answers  


ORA-01228: SET DATABASE option required to install seed database

1 Answers  


SQL-02118: Invalid row for a WHERE CURRENT OF operation

1 Answers  


ORA-29391: %s and string must be mandatory to create a mandatory plan directive

1 Answers  


NCR-01011: NCRS: Send message failure.

1 Answers  






ORA-07552: sftget: $GET failure

1 Answers  


ORA-29826: keyword FOR is missing

1 Answers  


ORA-38736: Wrong thread number string in flashback log file header.

1 Answers  


IMG-00710: unable to write to destination image

1 Answers  


O2I-00119: Warning reported by subsystem:

1 Answers  


ORA-31519: CDC subscription string already exists

1 Answers  


LSX-00211: value "~1S" whose fractional digits exceeds ~2d

1 Answers  


Categories