Oracle Error PLS-00454: with a returning into clause, the table expression cannot be remote or a subquery

Oracle Error Message

PLS-00454: with a returning into clause, the table expression cannot be remote or a subquery

Reason for the Error

A reference to a remote table or subquery was found in a sql statement with a returning into clause.

Solution

Do not refer to it, or do use a subsequent select statement.