如何解决:SQL错误:ORA-00604:在递归SQL级别1发生错误 [英] How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

问题描述

当我尝试删除表时出现错误

When I'm trying to drop table then I'm getting error

SQL Error: ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows
00604. 00000 -  "error occurred at recursive SQL level %s"
*Cause:    An error occurred while processing a recursive SQL statement
           (a statement applying to internal dictionary tables).
*Action:   If the situation described in the next error on the stack
           can be corrected, do so; otherwise contact Oracle Support.

推荐答案

我从错误中注意到以下一行.

I noticed following line from error.

exact fetch returns more than requested number of rows

然后，我在想.. Oracle期望排成一行，但是却得到多排.而且，只有双表具有该特征，该特征仅返回一行.

Then, I was thinking.. Oracle was expecting one row but It was getting multiple rows. And, only dual table has that characteristic, which returns only one row.

而且，我还记得，我在双表和执行双表时做了几处更改.然后找到多行.

And, I remember that, I have done few changes in dual table and when I executed dual table. Then found multiple rows.

现在，我截断了dual表，只插入了X值的行.而且，一切正常.

Now, I truncated dual table and inserted only row which X value. And, everything working fine.

这篇关于如何解决:SQL错误:ORA-00604:在递归SQL级别1发生错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！