Using Cursor Expressions. When the query is attempted in the editor, I receive the following:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
When I copy and paste the query into SqlPlus, the query executes without errors.
Reproduce using statement like:
SELECT
D.*, CURSOR(SELECT * FROM Emp WHERE DeptNo = D.DeptNo) Emps
FROM
Dept D
If the query does run, scrolling through the cursor values in the grid could lead to this error. Trying to scoll back to a previously viewed value doesn't work (scrolls back and shows a blank field) and closing the viewer window and reopening it doesn't help (doesn't bring up any data).
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center