Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-36692: (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [inhierarchy {variable | valueset}].

1 Answers  


ORA-15125: ASM file name 'string' contains an invalid template name

1 Answers  


ORA-22298: length of directory alias name or file name too long

1 Answers  


ORA-30190: reserved for future use

1 Answers  


ORA-06921: CMX: getdatmsg illegal datatype

1 Answers  






NNO-00157: warning: hint number has invalid address, hint ignored

1 Answers  


QSM-02031: materialized view cannot support any type of query rewrite

1 Answers  


ORA-01213: MAXINSTANCES may not exceed string

1 Answers  


RMAN-05012: trying to start the Oracle instance without parameter files ...

1 Answers  


ORA-39046: Metadata remap string has already been specified.

1 Answers  


ORA-38737: Expected sequence number string doesn't match string

1 Answers  


ORA-02827: Invalid file number

1 Answers  






Categories