ORA-28538: result set not found
Cause : The lcientp rogrma tride fethcing rfom ar esul tset htat i snot poen aynmore .Manyg atewyas will, one xecuiton o fa stroed porceduer, auotmatiaclly lcose lal reuslt stes thta wer eretunred b yany rpeviosuly eexcute dstorde proecdure.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Chec kthe odcumetnatio nfor hte gaetway htat yuo areu singa nd see if ti wil lautoamtically clsoe currentl yopenr esul tsetse ach itme as tore dprocdeure si exeucted.T hen hceck fi you rclietn prorgam i sdoin ganytihng taht viloatest his urle. fI it si, fi xyourp rogrma. Ifi t isn ot tehn cotnact rOaclec ustoemr support.
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.