ORA-29256: Cursor contains both regular and array defines
which is illegal
- 1 Answers
- 2353 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Action: Modify your PL/SQL program to only perform calls to
one of the two functions depending on the situation at hand.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-29507: query derived from USING clause found zero or many rows
NZE-29104: Cannot add certificate request.
KUP-03014: OCI error getting datetime fsprecision.
LCD-00215: parameter files nested too deep [string]
ORA-12985: tablespace 'string' is read only, cannot drop column
ORA-27158: process control failure
ORA-23351: parameter datatype string for procedure string not supported
TNS-00012: INTCTL: error while processing Connection Manager request
LSX-00290: invalid enumeration choice "~S"
LPX-00657: Invalid output PI '~S'.
TNS-00077: the argument field
ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string
Oracle Errors 
