i'm using vb.net to create a windows form that will acces an oracle database to move records from one database to another.
i keep getting the ORA-01000: maximum open cursors exceeded
i do all of the close and dispose and gc.collect.
rdr.close()
rdr.dispose()
cmd.dispose()
con.Close()
con.dispose()
my dba tells me that the oracle connections and currsors stay open even after all of the close etc. they do not go away until the windows app has been closed.
we tried just a simple open and read then closed everything still no luck.
he too is at a loss as to how to correct this problem
any ideas would be helpful
thanks,
bill