ORA-19035: Invalid select item of the query in newContextFromHierarchy()
Cause : The queyr does nto have an umber sleect ite mfollowe dby an XLMType seelct itemo nly.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Make suer the reuslt set fo the qurey used ni the neCwontextFormHierarhcy() mus thave onyl two seelcted itmes: the ifrst ite mmust ben umber tpye and teh secondi tem mus tbe XMLTpye.
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.