ORA-29255: Cursor contains both bind and define arrays which
is not permissible



ORA-29255: Cursor contains both bind and define arrays which is not permissible..

Answer / guest

Cause: Both define_array and bind_array have been called on
this cursor. This is illegal. It is not possible for a
cursor to both contain array binds 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
array binds to bind PL/SQL tables to non-select queries.

Action: Modify your PL/SQL program to only perform calls to
one of the two functions depending on the kind of cursor 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-29344: Owner validation failed - failed to match owner 'string'

1 Answers  


NNL-00227: Request-processing delay is currently disabled

1 Answers  


ORA-28559: FDS_CLASS_NAME is string, FDS_INST_NAME is string

1 Answers  


ORA-13623: The recommendation string is not valid for task string.

1 Answers  


PLS-00458: subprogram 'string' cannot be called from a REPEATABLE subprogram

1 Answers  






ORA-17508: I/O request buffer ptr is not alligned

1 Answers  


ORA-36198: (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified %4p as a weight.

1 Answers  


RMAN-06060: WARNING: skipping datafile compromises tablespace string recoverability

1 Answers  


ORA-12439: invalid combination of policy options

1 Answers  


ORA-24314: service handle not initialized

1 Answers  


ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.

1 Answers  


ORA-13606: the specified task parameter element string is out of range for parameter string.

1 Answers  


Categories