ORA-24813: cannot send or receive an unsupported LOB
Cause : An attempt was made to send a LOB across the network, but either the server does not support the LOB sent by the client, or the client does not support the LOB sent by the server. This error usually occurs when the client and server are running different versions of Oracle.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Use a version of the Oracle that supports the LOB on both the client and the server.
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.