ORA-08435: PICTURE MASK missing the leading sign when SIGN
IS LEADING specified



ORA-08435: PICTURE MASK missing the leading sign when SIGN IS LEADING specified..

Answer / guest

Cause: The input MASK passed to a UTL_PG RAW_TO_NUMBER
conversion routine had no leading sign, but the mask options
parameter specified a leading sign.

Action: Correct the input raw data or the mask options so
that they match.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01516: nonexistent log file, datafile, or tempfile "string"

1 Answers  


ORA-26046: REF column string expects scoped table name string; user passed in string.

1 Answers  


ORA-02720: osnfop: shmat failed

1 Answers  


PCC-02421: This host variable requires the use of an indicator variable

1 Answers  


RMAN-07522: CREATE TYPE privilege must be granted to user string

1 Answers  






ORA-22626: Type Mismatch while constructing or accessing OCIAnyData

1 Answers  


TNS-00111: Failed to get configuration data from file

1 Answers  


SQL*Loader-00128: unable to begin a session

1 Answers  


EXP-00052: error on row number of partition string

1 Answers  


CLSR-01001: Unsupported open mode number is specified

1 Answers  


ORA-07324: smpall: malloc error while allocating pga.

1 Answers  


ORA-38608: FI itemset minimum-length(string) should not be greater than maximum length(string)

1 Answers  


Categories