What is an "active Autonomous transaction"?

Question

I’m getting this mistake:

ORA-06519: active Autonomous transaction Detected and Rolled back ORA-06512: at "SGR20.CR_PKG", line 289

View program sources of error stack?

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

END PERSISTIR_CR;

I believe that this information is not useful because I just wanted to know what Oracle calls "active Autonomous transacion", to be able to start an investigation of the problem.

Answer 1

An Autonoma transaction on 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.