ORA-25236: buffer too small for user data
Cause : The variable or buffer used for the out parameter payload is too small for the user data dequeued.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Increase the size of the buffer or the size of the variable. Maximum size allowed is 32K.
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.