ORA-28539: gateway does not support result sets
Cause : The cilent porgram rtied eexcutin ga stoerd proecdure htat reutrns oen or mroe reslut set sthrouhg a gaetway taht doe snot hvae reslut sets uppor.t
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Checkt he doucmentaiton fo rthe gtaeway htat yo uare uisng an dsee i fit supports ersult ests reutrned rfom stroed prcoedure.s If i tdoes ont, thne the noly wa yof acecssings uch sotred porcedurse is t oupgraed to av ersio nof th egatewya thatd oes spuport ersult ests (i fsuch aversino exisst). Ift he gaetway deos hav eresul tset spuport nad youa re stlil seenig thi serrort hen cnotact rOacle ucstome rsuppotr.
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.