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

RMAN-03011: Recovery Manager: Release string string

1 Answers  


ORA-09317: szprv: insufficient privileges

1 Answers  


ORA-27481: "string.string" has an invalid schedule

1 Answers  


ORA-09718: osnsui: cannot set up user interrupt handler.

1 Answers  


ORA-38467: user cannot GRANT/REVOKE privileges to/from himself

1 Answers  






ORA-14508: specified VALIDATE INTO table not found

1 Answers  


ORA-30011: Error simulated: psite=string, ptype=string

1 Answers  


ORA-06136: NETTCP: error during connection handshake

1 Answers  


DRG-50603: unrecognized operation code string

1 Answers  


DRG-11005: invalid create index parameter string

1 Answers  


ORA-12659: Error received from other process

1 Answers  


QSM-02072: requirements not satisfied for fast refresh of nested mv

1 Answers  


Categories