Oracle Solution for Error ora-24787

Solution for Oracle Error ORA-24787

ORA-24787: remote cursors must be closed before a call completes

What triggered the Error:

e previous operation did not close all the remote cursors it opened. Since separated transactions are enabled, this is not allowed.

What should we do to fix it:

ose all remote cursors in each call, or start a regular (non-separated) transaction.