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



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

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

Post New Answer

More Oracle Errors Interview Questions

ORA-02804: Allocation of memory failed for log file name

1 Answers  


ORA-02399: exceeded maximum connect time, you are being logged off

1 Answers  


AMD-00121: dimension #string: analytic workspace hierarchy not specified

1 Answers  


ORA-01214: MAXLOGHISTORY may not exceed string

1 Answers  


ORA-16701: generic resource guard request failed

1 Answers  






ORA-30121: 'string' is not an allowable value for 'string'

1 Answers   CTS,


TNS-00312: Connection Manager: Failed to get version information

1 Answers  


RMAN-06111: changed backup piece unavailable

1 Answers  


TNS-12513: TNS:service handler found but it has registered for a different protocol

1 Answers  


DRG-50851: SQL execute failed

1 Answers  


LSX-00294: field "~S" produced multiple hits

1 Answers  


ORA-29362: plan directive string, string does not exist

1 Answers  


Categories