Oracle Error Message
PLS-00419: reference to remote attribute not permitted
Reason for the Error
An attempt was made to reference a remote cursor attribute, which is not allowed. For example, the code might look like IF SQL%NOTFOUND@newyork THEN …
Solution
Do not try to reference a remote cursor attribute.