[gnome-db] ORA-01000: maximum open cursors exceeded
Andrea Zagli <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <[email protected]> |
i wrote a little program that read from oracle and write to postgresql between read and write there's a recursive function that, i think, maxes out at a depth of 10; every call open a gdadatamodel from oracle i'm quite sure that i close every opened gdastatement and gdadatamodel but after a while (i didn't count) i got the error of the mail subject what am i wrong? is there a way to force cursors closing? there's a trick? i solved increasing system number of cursors that can be opened, but i don't whant to do that thanks in advance PS: i don't know oracle; i use it because the data we have there