[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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.