ORA-01000：超出最大打开游标如何解决此错误 [英] ORA-01000: maximum open cursors exceeded How to resolve this error

问题描述

未指定错误

ORA-00604：递归SQL级别1发生错误

ORA-01000：超出最大打开游标

ORA- 01000：超出最大打开游标





我有一个查询，在PL / SQL中执行时得到的完美，但是从我的页面开始更新它给出了上面的错误。



有人可以帮助我吗？

Unspecified error
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded


I have a query which when executed in PL/SQL gets exceuted perfectly, but from my page for update it gives above error.

Can Anybody please help me ?

推荐答案

你搜索过Google了吗？这个错误？检查这些

ORA-01000：最大开放游标超出提示 [ ^ ]

ORA-01000：超出最大开放游标 - 如何避免 [ ^ ]

ORA-01000：超出最大打开游标数 [ ^ ]

Did you search Google for this error? Check these
ORA-01000: maximum open cursors exceeded tips[^]
ORA-01000: maximum open cursors exceeded - How To Avoid[^]
ORA-01000: Maximum Open Cursors Exceeded[^]

ORA-00604：在递归SQL级别1发生错误

这是真正的问题：与从网页提供的数据，您可以创建无限嵌套的调用。修复您在此处调用的存储过程，以处理页面中的数据。

ORA-00604: error occurred at recursive SQL level 1
That's the real problem: with the data you feed from your web page, you create infinitely nested calls. Fix the stored procedure you call here to cope with the data from your page.

这篇关于ORA-01000：超出最大打开游标如何解决此错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！