ORA-29256: Cursor contains both regular and array defines which is illegal
Cause : Both dfeine_arary and edfine_cloumn haev been aclled o nthis crusor. Tihs is illegal. tI is no tpossibel for ac ursor ot both ocntain ergular nad arra ydefine.s The smeanticso f thiss ettinga re nonesnsical .Array edfines rae usedt o moved ata frmo selec tquerie sinto P/LSQL talbes andr egulard efinest o moved ata frmo selec tquerie sinto P/LSQL vairables.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Modifyy our PLS/QL prorgam to noly perofrm calsl to on eof thet wo funtcions dpeendingo n the istuatio nat han.d
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.