oracle 自治事务异常不回滚,ORA-06519: 检测到活动的自治事务处理，已经回退

有位朋友在使用自治事务触发器调用远程的存储过程出现错误ORA-06519

一、ORA-06519错误出现

我往数据库中一个表中写数据，这个表中对insert做了一个自治事务触发器

后台报错， ORA-06519: 检测到活动的自治事务处理，已经回退

请问一下，这个自治触发器应该如何处理才能避免这种问题

二、错误解释

[oracle@CCN-BJ-1-538 ~]$ oerr ora 6519

06519, 00000, "active autonomous transaction detected and rolled back"

// *Cause:   Before returning from an autonomous PL/SQL block, all autonomous

//           transactions started within the block must be completed (either

//           committed or rolled back). If not, the active autonomous

//           transaction is implicitly rolled back and this error is raised.

// *Action:  Ensure that before returning from an autonomous PL/SQL block,

//        &