[gnome-db] ORA-01000: maximum open cursors exceeded



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



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]