User Profile

Sanmargar

Registered Developer

Last Activity: 28 Oct 2025, 03:24

Joined: 5 Feb 2014

Sanmargar replied to [Oracle] Open cursor leak during ADD: per-row reselect by ROWID opens a new cursor and doesn’t close it → ORA-01000 after ~300 inserts

in Technical Q&A

19 Oct 2025, 13:56
I confirm, in 13.0 2025-10-17, the issue with ORACLE I described earlier no longer occurs.

Thank you....

See more | Go to post
Leave a comment:
Sanmargar replied to [Oracle] Open cursor leak during ADD: per-row reselect by ROWID opens a new cursor and doesn’t close it → ORA-01000 after ~300 inserts

in Technical Q&A

5 Oct 2025, 00:20
For me, the need to obtain the ROWID was about fetching the data after the record is inserted, because some values are changed by triggers. I need those...

See more | Go to post
Leave a comment:
Sanmargar replied to [Oracle] Open cursor leak during ADD: per-row reselect by ROWID opens a new cursor and doesn’t close it → ORA-01000 after ~300 inserts

in Technical Q&A

3 Oct 2025, 14:44
The BuiltInDS example I shared was just a simplified test case for you and to verify the behavior.
Originally, I observed the problem on the server...

See more | Go to post
Leave a comment:
Sanmargar replied to [Oracle] Open cursor leak during ADD: per-row reselect by ROWID opens a new cursor and doesn’t close it → ORA-01000 after ~300 inserts

in Technical Q&A

3 Oct 2025, 12:53
Bug reproduction scenario

In the built-in-ds sample, I added a custom [Add300] button that inserts 300 records using sendQueue.
...

See more | Go to post

Last edited by Sanmargar; 3 Oct 2025, 13:36.
Leave a comment:

No activity results to display

Announcement

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment: