Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to inspect a cursor variable in a debug session?

pacoKASFeb 11 2010 — edited Feb 16 2010
In a function inside the body of a package I do...

Example:

V_SITUACIONESACTYHIST C_SITUACIONESACTYHIST%ROWTYPE;
...

BEGIN
....
FOR v_SituacionesACTyHIST IN c_SituacionesACTyHIST( p_id_DECE400, p_idpers )
LOOP

IF ( V_SITUACIONESACTYHIST.ESTADO_SITUACION = 'S' ) THEN
v_hay_regs_hist:=1;
END IF;

...

END LOOP;

where the cursor variable c_SituacionesACTyHIST is declared in the specifications package (Is this the problem, because is a global declaration?).

When debugging I cannot inspect the value of V_SITUACIONESACTYHIST.ESTADO_SITUACION or whatever cursor variable field; I always obtain "NULL" as value...

Why?

How can I see the value of that variables?

I have the same problem in v2.1 and 1.5.5 version of sqldeveloper.

Thanks.

Edited by: pacoKAS on 11-feb-2010 0:14

Edited by: pacoKAS on 11-feb-2010 0:17

Edited by: pacoKAS on 11-feb-2010 0:17

Edited by: pacoKAS on 11-feb-2010 0:19

Edited by: pacoKAS on 11-feb-2010 0:21

Edited by: pacoKAS on 11-feb-2010 0:22

Edited by: pacoKAS on 11-feb-2010 0:22
This post has been answered by _Dylan_ on Feb 16 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2010
Added on Feb 11 2010
6 comments
1,809 views