Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Records deleted in an autonomous transaction within stored procedure still available later inside the procedure #298

Open
malpacasville opened this issue Mar 2, 2023 · 0 comments

Comments

@malpacasville
Copy link

I have a stored procedure that deletes some expired data using "in autonomous transaction do", it does this so the delete isn't rolled back if the procedure throws an exception later. I am finding the data still exists for statements outside the autonomous transaction later in the procedure. (I'm using db.execute with pooling).

I could rework how this particular function works to get around it, but I don't know where else in our system it might cause issues.
The procedure works fine when calling it from SQL manager or a different API connection to the database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant