What is an "active autonomous transaction"?

Question

What is an "active autonomous transaction"?

Navigation

#1 by (1 votes)

1

I'm getting this error:

ORA-06519: active autonomous transaction detected and rolled back   ORA-06512: at "SGR20.CR_PKG", line 289

View program sources of error stack?

Before someone asks what the error is giving in an Oracle Package (PKG) and the line pointed to is the end of the package code:

END PERSISTIR_CR;

I think this information is not useful because I just wanted to know what Oracle calls "active autonomous transaction", so I can start with an investigation of the problem.

sql oracle

asked by anonymous 06.08.2014 / 17:00

1 answer

Validation with Toast and insertion in the bank Find files on Xamarin Android

score 1 · Accepted Answer

A standalone transaction in oracle works as follows: a procedure / package / function initiates a new transaction and commits the changes made, without impacting the active transaction that called it.