ORA-06519错误信息是“active autonomous transaction detected and rolled back”,意思是检测到一个活动的自主事务,并且该事务被回滚了。这通常发生在自主事务尝试在不允许自主事务的环境中提交或回滚时,例如在一个已经提交或回滚的父事务中。 3. 描述可能导致ORA-06519错误的情况 在父事务提交或回滚后执行自主事务:如...
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 // ...
GRANT SELECT ON SYS.dba_users TO POWERBI_DEV2; 2) a function CREATE OR REPLACE function SYSTEM.Assign_role_powerbi_f --authid current_user return number authid current_user as --pragma autonomous_transaction; HOSTNAME varchar2 (60); GEBR varchar2 (60); PROG varchar2 (60); ...
ORA-06519: active autonomous transaction detected and rolled back 2016-12-13 18:31 −... 左正 0 2725 Spring:JTA transaction unexpectedly rolled back (maybe due to a timeout) 事务超时 2019-12-23 14:26 −采用spring框架时,在 Service 层的方法中加上注解 @Transactional 就可以将这个方法加上...
ORA-06519: active autonomous transaction detected and rolled back,这个问题一般怎么解决?现在忙 待会贴详细代码先给些路子。。给位大大们在自治事务中加上commit
在自治事务中加上commit 分类: ORACLE 好文要顶 关注我 收藏该文 微信分享 左正 粉丝- 307 关注- 33 +加关注 0 0 « 上一篇: C#加密解密大全 » 下一篇: 关于Oracle AUTONOMOUS TRANSACTION(自治事务)的介绍 posted @ 2016-12-13 18:31 左正 阅读(2725) 评论(0) 编辑 收藏 举报 刷新...
因为你想想，当你真的看到结果是没考过、没录取时，你反而不会焦虑了，不会不安了。 已经是既成事实...
ORA-06519: active autonomous transaction detected and rolled back Oct 2 '15, 03:12 AM Hi, In our application creating the new user and granting the role to the new user.this i have done by instead of view,trigger and calling the procedure from trigger and declared the procedure as an...