I am using a dataset in VB.Net to populate a listview. I am getting an error "ORA-01000: maximum open cursors exceeded". There are 1700+ records that I am retrieving. Our Oracle database has a limit of 300 cursors and I am hitting 301 when retrieving the records.
From researching this I found out that I need to change HOLD_CURSOR to NO and RELEASE_CURSOR to YES in Oracle, but I cannot find anything on how to do this in VB.Net.
Does anyone know how to do this?