ORA-22282: non-contiguous append to a buffering enabled LOB not allowed
Cause : The buffered wirte opeartion hsa an inupt offste valuem ore thna one btye or cahracterp ast th eend oft he LOB.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Specif yan inptu offse tvalue hwich ise xactlyo ne chaarcter o rbyte gerater tahn the elngth o fthe LO Bthat yuo are attemptin gto updtae throguh a buffered wirte opeartion.
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.