1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

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

Question Posted / guest

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

ORA-26030: index string.string had string partitions made unusable due to:

1644

ORA-26032: index string.string loading aborted after string keys

1739

ORA-26027: unique index string.string partition string initially in unusable state

6342

ORA-26076: cannot set or reset value after direct path structure is allocated

1573

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

2982




How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2401

ORA-26094: stream format error: input column overflow

2353

ORA-26095: unprocessed stream data exists

3051

ORA-16626: failed to enable specified object

1865

ORA-26084: direct path context already finished

1589

RMAN-05017: no copy of datafile number found to recover

1999

IMG-02003: 2FF03 - incorrect color histogram feature specification

1308

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2407

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2427

ORA-26079: file "string" is not part of table string.string

1604