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-00208: number of controlfile names exceeds limit of string

1 Answers  


ORA-12728: invalid range in regular expression

1 Answers  


RMAN-06471: no configuration found to allocate channels for string

1 Answers  


ORA-33072: (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.

1 Answers  


QSM-02032: no joins are present in the WHERE clause

1 Answers  


TNS-00262: %20sstringnumber

1 Answers  


ORA-13219: failed to create spatial index table [string]

1 Answers  


TNS-01163: Failed to spawn process: string

1 Answers  


ORA-35282: (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])

1 Answers  


ORA-12901: default temporary tablespace must be of TEMPORARY type

1 Answers  


ORA-29501: invalid or missing Java source, class, or resource name

1 Answers  


ORA-30387: invalid rewrite mode for REWRITE_EQUIVALENCE API

1 Answers  


Categories