I was testing a function that returns a sys_refcursor. One of the outcomes I have is to check the # of rows in the returned cursor. I defined the cursor attributes with a query. After the test case was set up, the attributes of the returned cursor changed. When I went into my test case to update the query that the cursor is based on, I got:
ORA-06504: PL/SQL: Return types of Result Set variable or query do not match
Is there some other way to update the attributes that are expected in the returned cursor?