Problem with distributed queries in Oracle 7.3.4

Hi folks,

this is my problem:

in a package-function, I am using several cursors performing distributed queries. I decided to use the FOR ... LOOP statement because I don't want to worry about opening and closing the cursors. The function terminates with an error message 'maximum of open cursors exceeded' on the remote database and if I look at the v$_open_cursors in that database I can see more than 50 open cursors. Oracle doesn't close these cursors even if I commit the transaction. They will be closed on terminating the database link or disconnecting from both databases. What am I doing wrong ? Is there a special init.ora-Parameter I have to set ? I have scanned the documentation (server distributed systems Vol I/II) but I couldn't find a hint concerning this problem.

Any suggestions ?

Jens Received on Thu May 20 1999 - 09:57:16 CDT