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-31437: duplicate change set string

1 Answers  


LPX-00253: missing required version number in XML declaration

1 Answers  


NZE-29155: continuous key pair consistency check self-test failure

1 Answers  


DRG-11521: encounter error when updating a LONG or LONG RAW column

1 Answers  


KUP-04000: error initializing IO state for file string in string

1 Answers  






ORA-27020: named devices not supported

1 Answers  


ORA-16193: Primary and standby network encryption mismatch

1 Answers  


ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

1 Answers  


ORA-22896: cannot have both scope and referential constraint on REF column "string"

1 Answers  


TNS-04016: Connecting to string

1 Answers  


ORA-02062: distributed recovery received DBID string, expected string

1 Answers  


ORA-30729: maximum number of columns exceeded

1 Answers  


Categories