How to fix the Oracle error ORA-28539: gateway does not support result sets?

In this post, you’ll learn more about the Oracle ErrorORA-28539: gateway does not support result sets with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28539: gateway does not support result sets

Reason for the Error ORA-28539: gateway does not support result sets

The client program tried executing a stored procedure that returns one or more result sets through a gateway that does not have result set support.

How to fix the Error ORA-28539: gateway does not support result sets ?

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

Check the documentation for the gateway that you are using and see if it supports result sets returned from stored procedures. If it does not, then the only way of accessing such stored procedures is to upgrade to a version of the gateway that does support result sets (if such a version exists). If the gateway does have result set support and you are still seeing this error then contact Oracle customer support.