Oracle DBA, How To, Error, Cause and Action

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


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.

No comments:

Post a Comment

Thanks for your comment.