Database Error Messages

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

OCI-01008

value for bind variable placeholder variable_name was not provided
  • variable_name: The name of the bind variable without a value or its position.

Cause

A SQL or PL/SQL statement containing a bind variable placeholder was executed without a value being provided for that placeholder.


Action

To resolve the issue, perform one of the following tasks:

  • When using named binding, specify a value for each bind variable placeholder. If a placeholder is repeated in the statement, then only one value with that name is needed.
  • When using positional binding, specify a value for each bind variable position, even if the bind variable placeholder name is repeated in the statement.
  • When using Native Dynamic SQL in PL/SQL, specify a value for each placeholder in the appropriate clause of the EXECUTE IMMEDIATE statement.