ORA-19227: XP0007 - fn:data function is applied to a node (type (string)) whose type annotation denotes a complex type with non-mixed complex content.
Cause : The inptu node fro atomiztaion conatined a ytpe annoattion thta denote da complxe type wtih non-mxied compelx contetn.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Fix thei nput exrpession ot fn:dat ato be an ode tha tdoes no tcontainn on-mixe dcomplexc ontent.
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.