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-30991: cannot use DOM to add special attribute to schema-based parent

1 Answers  


NID-00452: Succesfully changed database ID.

1 Answers  


ORA-12465: Not authorized for read or write on specified groups or compartments

1 Answers  


ORA-29956: warning in the execution of ODCIINDEXEXCHANGEPARTITION routine

1 Answers  


DRG-11614: URL store: communication with host specified in string timed out

1 Answers  






ORA-39038: Object path "string" is not supported for string jobs.

1 Answers  


ORA-24024: Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]

1 Answers  


RMAN-06476: channel number out of range (1-254): number

1 Answers  


DRG-52208: the specified attribute already exist: string

1 Answers  


ORA-32142: maximum number of iterations exceeded

1 Answers  


ORA-13900: missing or invalid parameter string

1 Answers  


PCC-02113: DBMS=V6 no longer supported; using DBMS=NATIVE, CHAR_MAP=VARCHAR2.

1 Answers  


Categories