ORA-29256: Cursor contains both regular and array defines which is illegal
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 or SQL tables and regular defines to move data from select queries into PL or SQL variables.
Action: Modify your PL or SQL program to only perform calls to one of the two functions depending on the situation at hand.
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 or SQL tables and regular defines to move data from select queries into PL or SQL variables.
Action: Modify your PL or SQL program to only perform calls to one of the two functions depending on the situation at hand.
No comments:
Post a Comment