ORA-06563: top level procedure/function specified, cannot have subparts
Cause : The name to be resolved was specified with three parts (a.b.c) but the a.b part resolves to a top level procedure or function (which don't have nested procedures). This can also happen with a two-part name, a.b, where a is a synonym for a top level package or procedure.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Specify a procedure/function within a package, or a top level procedure/function.
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.