Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,055 questions
Why oracle cursors are not closed with VS 2019
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 1%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dadon
0
Reputation points
We have developped an application using VS 2013 and targeting Oracle database. The application is working smoothly since several year. We compiled our source code with VS 2019 with same framework 4.5 and same database. But while running our application under VS 2019, we noticed that all oracle cursors remained opened and finally crashed with error ORA-01000, maximum number of opened cursors exceeded. I am battling with this since several days, any help is most welcome.
Visual Studio
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT 30,356 Reputation points Microsoft Vendor2023-09-27T13:49:58.7133333+00:00 Hello @Dadon,
Welcome to Microsoft Q&A forum.
Version/rules of programming languages may be changed/improved, perhaps the issue is related to code and project type. But the error looks is an oracle error, is it possible to increase the count limit of the opened cursors?
Sign in to comment
Sign in to answer