Oracle Database Error Code ORA-29256 Description :
Cursor contains both regular and array defines which is illegal
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 :
Modify your PL/SQL program to only perform calls to one of the two functions depending on the situation at hand.
Search Oracle Error Codes and Descriptions:
1 Comment Already
Similar Errors
Please Leave Your Comments Below