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

TNS-02516: No data available

1 Answers  


ORA-13901: Object string was not found.

1 Answers  


LPX-00207: expected "[" at the start of conditional section

1 Answers  


RMAN-06530: CHANGE ... KEEP not supported for backup set which contains archive logs

1 Answers  


PLS-00460: REPEATABLE subprogram 'string' has to be RNDS, WNDS, RNPS, and WNPS

1 Answers  


TNS-01102: TNS application contacted was not the listener

1 Answers  


DRG-12503: error while creating or dropping stoplist

1 Answers  


IMG-00547: invalid channelOrder specified

1 Answers  


NNO-00808: Error connecting to region database

1 Answers  


ORA-02140: invalid tablespace name

1 Answers  


ORA-01025: UPI parameter out of range

1 Answers   TCS,


ORA-07471: snclrd: name translation error of sgadef.dbf file name.

1 Answers  


Categories