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

NPL-00308: requested ASN.1 class string does not match received class string

1 Answers  


SQL*Loader-00655: cannot load object-relational XML attribute using direct path

1 Answers  


ORA-06906: CMX: cannot get maximum packet size from CMX

1 Answers  


UDI-00005: unexpected End-Of-File encountered while reading input.

1 Answers  


ORA-16805: Change of LogXptMode property violates overall protection mode.

1 Answers  






ORA-01252: cannot prevent writes - file string in recovery manager backup

1 Answers  


VID-00705: unsupported input format

1 Answers  


DRG-11859: Data Transfer Interrupted

1 Answers  


PLS-01424: Non-ANSI order of clauses

1 Answers  


RMAN-00600: internal error, arguments [string] [string] [string] [string] [string]

1 Answers  


ORA-07683: sou2os: $SETPRV reset error

1 Answers  


ORA-31006: Path name segment length string exceeds maximum length string

1 Answers  


Categories