Database Error Messages

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

SQL-02147

ANSI Dynamic occurrence value out of range

Cause

The value clause in a dynamic GET or SET statement is less than one or greater than MAX given for descriptor allocation.


Action

Supply a number for the VALUE clause between 1 and the MAX occurrences supplied when the descriptor was allocated.