Problem viewing cursor value in debug mode
533736Sep 14 2006 — edited Sep 15 2006Hi eveybody!
I'm French and new here.
I know some topics deal with my subject but I don't really understand.
Here's my environnement :
Win2000 / ORA 9iR2 / SQL DEVELOPPER 1.0.0.15.57
As some people say when i'm in debug mode (after compiling my procedure PL/SQL for debug) I can't see any value of my cursors !
------------------------------------------------------------------------------------------------------------------------------
Ex :
CURSOR cur IS
SELECT COL1, COL2
FROM TABLE1;
v_cur cur%ROWTYPE;
For v_cur in cur
Loop
If v_cur.COL1 = 'toto' then
'do something' ;
End if;
End Loop;
-------------------------------------------------------------------------------------------------------------------------------
When I run this step by step in debug mode I can't see the data of my cursor in the data or smartdata pane.
The values of my cursor is allways null !
I guess I'm not the only one to see that bug.
My question is should I wait a new release of sql developer or is there any solution for this problem?
Anyway I want to congratulate the developers team who create this tool which is fabulous! It makes me forget TOAD and it's totally free.
Thanks a lot for this job.
Greg