Oracle DB Error ORA-28538 result set not found

The following is the cause of this error:

The client program tried fetching from a result set that is no longer open. Many gateways will, on execution of a stored procedure, automatically close all result sets that were returned by any previously executed stored procedure.

Action you can take to resolve this issue: Check the documentation for the gateway that you are using and see if it will automatically close currently open result sets each time a stored procedure is executed. Then check if your client program is violating this rule. If it is, fix your program. If it is not, contact Oracle Support Services.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related