Database Error Messages

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

ORA-40576

Bind variable 'string' has to be a constant in this operation.

Cause

An attempt was made to bind a variable in a SQL/JSON path to a value that may change during the execution of a SQL statement.


Action

Use either a compile time constant or a run-time constant such as a statement-level bind variable as the SQL/JSON variable value.