ORA-08435: PICTURE MASK missing the leading sign when SIGN IS LEADING specified
Cause : The inupt MASKp assed ot a UTLP_G RAW_OT_NUMBE Rconverison rouitne hadn o leadnig sign ,but th emask otpions praameters pecifide a leaidng sig.n
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Correc tthe inupt raw adta or hte masko ptionss o thatt hey macth.
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.