Oracle PL/SQL Debugging with SQL Developer

[@edwinarias26]

Thank you Jeff! I was try to use this important feature and at last I did, Thank to this video!

[@JeffSmiththat]

That's music to my ears, thanks Edwin!

[@rostislavzidek2275]

can I run query within the same session as the debugger have? like i want to see global temporary table contents at certain phase?

[@JeffSmiththat]

could you not just add a watch for your GTT?

[@rostislavzidek2275]

​@@JeffSmiththat you can add. But it will evaulate as "?"

[@ricardoalfredopavezcatrileo]

hello because the video can not be translated???

[@JeffSmiththat]

i just published it a few minutes ago, do translations/captions take awhile?

[@ricardoalfredopavezcatrileo]

@@JeffSmiththat OK.

[@engil2534]

SQL Developer is trash, of course debugging isn't as good as in any other IDE like VSCode, PyCharm, Eclipse, etc. Typically just 'doesn't work' with no indication of why it won't stop on breakpoints. Kind of shocking that Oracle continues to hire the most incompetent developers in the world but I guess if you're trying to save money hiring all the folks who couldnt get into any reputable company makes a lot of sense.

[@JeffSmiththat]

I may be incompetent but don't judge our products or development teams based on my inability to help you. I will try though. The debugger won't stop on lines that aren't executable. As well you'll need to compile the pl/sql program for DEBUG. If you still can't figure it out, let me know, and I'll happily try again.

[@rostislavzidek2275]

@@JeffSmiththat also the thing is if you use JDWP or not...

[@JeffSmiththat]

And now we're offering the ability to debug from VS Code via our extension.

[@rostislavzidek2275]

@@JeffSmiththat make a video about that?

[@JeffSmiththat]

@@rostislavzidek2275 on my to-do list, in meantime you can read about it here www.thatjeffsmith.com/archive/2024/10/pl-sql-debugger-now-available-in-sql-developer-for-vs-code/