ORA-39765: stream must be reset before used in a column array conversion
Cause : The stream was completely loaded, but has not been reset yet.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Reset loaded streams after load returns OCI_SUCCESS, OCI_NO_DATA, or OCI_NEED_DATA. The stream can then be used in a column array to stream conversion.
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.