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!

Inspect variables in debugger

Álvaro GonzálezJan 15 2020 — edited Jan 15 2020

I'm debugging a stored procedure and SQL Developer displays all my variables but almost every value shows up as NULL. Fiddling with settings, I've discovered that adding the "Hex Value" column makes actual values finally show up in "Data" tab but not in "Smart Data" or "Watches". I also seem some other glitches such as one same variable (a cursor rowtype) being listed twice.

pastedImage_1.png

pastedImage_3.png

pastedImage_0.png

Is the builtin debugger meant to be fully functional? Are there known issues or incompatibilities? Am I missing something?

Comments
Post Details
Added on Jan 15 2020
1 comment
236 views