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!

Problem viewing cursor value in debug mode

533736Sep 14 2006 — edited Sep 15 2006
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2006
Added on Sep 14 2006
3 comments
1,984 views