Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-29256

Cursor contains both regular and array defines which is not valid.

Cause

Both DEFINE_ARRAY and DEFINE_COLUMN were called on this cursor. It is not valid for a cursor to contain both regular and array defines. Array defines are used to move data from SELECT queries into PL/SQL tables and regular defines are used to move data from SELECT queries into PL/SQL variables.


Action

Modify your PL/SQL program to only perform calls to one of the two functions.