ORA-28539: gateway does not support result sets ORACLE 报错 故障修复 远程处理

文档解释

ORA-28539: gateway does not support result sets

Cause: 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.

Action: 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.

ORA-28539: Gateway连接不支持结果集返回。

官方解释

常见案例

一般处理方法及步骤

1.确保你的sql语句正确，以确保它不会返回任何结果集。

2.考虑使用不同的连接方法来代替网关连接，如ODBC（Open DataBase Connectivity）。

3.最后，请尝试升级Oracle数据网关，以确保使用最新版本的gadget。