How to fix the Oracle error ORA-06595: REF CURSOR parameters are not supported in forwarded RPC calls?

In this post, you’ll learn more about the Oracle ErrorORA-06595: REF CURSOR parameters are not supported in forwarded RPC calls with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-06595: REF CURSOR parameters are not supported in forwarded RPC calls

Reason for the Error ORA-06595: REF CURSOR parameters are not supported in forwarded RPC calls

An attempt was made to make a forwarded RPC call with a REF CURSOR parameter.

How to fix the Error ORA-06595: REF CURSOR parameters are not supported in forwarded RPC calls ?

You can fix this error in Oracle by following the below steps

Either call the remote function directly (i.e., not by way of forwarding), or move the remote function to a database where it can be called directly.