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 change variable value at debugging time?

Blue BirdDec 14 2018 — edited Dec 17 2018

I'm debugging through stored procedure in SQLDev 18.3. For example that at one point I notice that some calculated variable value is wrong. I double click on that wrong value in Data panel and Modify Value dialog appear. I change it into correct (other) value. in below example I changed l_Num1 from original 10 to 20 before I execute line 4 which assign value to l_Num2. But at the end l_Result is still 15 (10+5), like my modification didn't apply.

How I have to change value (or use correct steps) so this modification will be applied? I assume that value can be changed otherwise I wouldn't get Modify Value dialog.

Thanks,

BB

pastedImage_0.png

This post has been answered by Glen Conway on Dec 15 2018
Jump to Answer
Comments
Post Details
Added on Dec 14 2018
17 comments
1,732 views