ORA-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.