Nested cursor error in 7.1 (works in 7.0)

[MikeM]

Run the following in an SQL window:

SELECT dummy, CURSOR (SELECT dummy FROM dual) FROM dual;

In version 7.0 you can view the contents of the cursor.

In version 7.1 the error "ORA-01001: invalid cursor" is displayed when trying to view the contents of the cursor.

We use a lot of nested cursors in our code and under 7.1 we can no longer test our select statements.

 

[MikeM]

sorry...

Pl/SQL Dev Version 7.1.1.1339
Oracle9i Enterprise Edition Release 9.2.0.4.0 on Tru64
and
Oracle9i Enterprise Edition Release 9.2.0.6.0 on HP-UX

 

[Natalia O.]

It's the same with
Oracle9i Enterprise Edition Release 9.2.0.6.0 and
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0

 

[Marco Kalter]

We'll check it out.

 

[MikeM]

Hi Marco,

any update on this?

Thanks,
Mike

 

[Marco Kalter]

Not yet. I will post here when we do.