ORA-49040
Path variable variable_name is never declared.
- variable_name: The variable name not referencing a path variable.
Cause
The variable in the IN clause is either never declared or not a path variable.
Action
Reference only path variables in the IN clause.