Recent content by Mark Zuchowski

I am not sure what you mean by "Are the cursor instances different for the 2 result sets?". Both of the above queries return the same fields and the nested cursors also return the same number of fields. The issue only surfaces with the second query (with the where clause) when run from pl/sql...

I am getting an error (ORA-01001:invalid cursor) when I have a where clause on a SQL statement that has a cursor expression when I try to access the cursor from the cursor expression by clicking on the "..." in the result cell for the cursor. If I remove the where clause I do not get the error...