Ora-29256 Cursor contains both regular

 ORA-29256 Cursor contains both regular and array defines which is illegal

    Oracle Database Error Messages Code ORA-29256 Help About Description;

Cursor contains both regular and array defines which is illegal.

    Problem Error Cause;

Both DEFINE_ARRAY and DEFINE_COLUMN have been called on this cursor. This is illegal. It is not possible for a cursor to both contain regular and array defines. The semantics of this setting are nonsensical. Array defines are used to move data from select queries into PL/SQL tables and regular defines to move data from select queries into PL/SQL variables.

    How to Solve; ORA-29256 Cursor contains both regular and array defines which is illegal?

    Fix Action Solve;

Modify your PL/SQL program to only perform calls to one of the two functions depending on the situation at hand.