Oracle Error ORA-22819: scope of input value does not correspond to the scope of the target

Oracle Error Message

ORA-22819: scope of input value does not correspond to the scope of the target

Reason for the Error

An attempt to operate on a REF value scoped to a different table than the expected one

Solution

Use a ref which is scoped to the expected table and retry the operation