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

IMG-00546: invalid page number specified

1 Answers  


RMAN-06560: WARNING: backup set with key number will be read number times

1 Answers  


RMAN-06220: Creating automatic instance

1 Answers  


LSX-00284: duplicate constraint name "~S"

1 Answers  


ORA-19646: cannot change size of datafile string from string to string

1 Answers  


ORA-01697: controlfile is for a clone database

1 Answers  


NPL-00419: received ASN.1 object identifier with sub-identifier that is too large

1 Answers  


PROC-00006: User does not have permission to perform a cluster registry operation on this key.

1 Answers  


PCC-02383: Expecting an expression of type OCIExtProcContext

1 Answers  


SQL-02102: Inconsistent cursor cache. No global cursor entry.

1 Answers  


ORA-13781: The tuning task does not exist.

1 Answers  


ORA-09912: Malloc of name buffer(s) failed.

1 Answers  


Categories