Oracle Error Message
ORA-08469: must use the SIGN IS SEPARATE clause in mask options
Reason for the Error
A signed numeric entry with DISPLAY usage was converted using a non-defaulted character set and its PICTURE character-string contains an S. In these circumstances, a SIGN IS SEPARATE clause must be specified in the mask options.
Solution
Either specify a valid SIGN IS SEPARATE clause in the mask options, use the defaulted character set, or don’t specify an S in the PICTURE character-string.
