暂无图片
分享
李锴
2019-04-18
执行delete提交报错

SQL> delete from foo where a=1;

1 row deleted.

SQL> commit;

commit

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-06550: line 1, column 7:

PLS-00306: wrong number or types of arguments in call to 'SYNCRN'

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

收藏
分享
2条回答
默认
最新
cy

After Upgrade to 11.2.0.4 Unable to Delete Any Rows from Table with Context Index due to Error: "PLS-00306: wrong number or types of arguments in call to 'SYNCRN'" (文档 ID 1586704.1)

 

After database upgrade to 11.2.0.4 cannot delete any rows from a table with context index due to PLS-306 error:
 

SQL> delete from foo where a=1;

1 row deleted.

SQL> commit;
commit
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

 

Changes

 Database has been upgraded to 11.2.0.4, applied Patch 13390677

Cause

The cause of this problem has been analyzed in unpublished Bug 17501296. Commit callback procedure ctxsys.syncrn is not in sync with 11.2.0.4 C-code

Solution

To resolve the problem apply Patch 17501296


暂无图片 评论
暂无图片 有用 0
李锴
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏