Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-01121: cannot rename database file string - file is in use or recovery

1 Answers  


PCC-00082: Length and scale specifications must be an integer

1 Answers  


TNS-12538: TNS:no such protocol adapter

1 Answers  


ORA-31479: could not create LogMiner session

1 Answers  


QSM-01061: illegal query expression

1 Answers  






NID-00490: LOG being redirected to STDERR due to errors.

1 Answers  


PROT-00001: Failed to initialize ocrconfig

2 Answers  


ORA-26690: datatype not supported at non-Oracle system

1 Answers  


ORA-19623: file string is open

1 Answers  


TNS-12564: TNS:connection refused

6 Answers   Oracle,


ORA-14329: domain index [sub]partitions cannot be renamed in this clause

1 Answers  


QSM-01005: no query rewrite when query has slave SQL

1 Answers  






Categories