ThatJeffSmith

Tag: debug

Debugging PL/SQL Collections Revisited

I talked about using the debugger to inspect a collection in PL/SQL using SQL Developer a few years ago. It’s been so long in fact that when Steven asked if I had a post on it, I said ‘no.’ We had gotten a question from a reader on how to look at collections while you’re […]

Similar Posts by Subject Areas: , , ,

Just another GIF: Debugging PL/SQL

Start a debug session…step over some code…look at a variable…run to a breakpoint…investigate the data in a PL/SQL table…step into another program…check out the callstack. Just another day in animated GIFs and showing you what SQL Developer is capable of. If you’re curious or want more info, hit the ‘debug’ link at the end of […]

Similar Posts by Subject Areas: , , ,

How to Start the PL/SQL Debugger

Starting the debugger CAN be as simple as hitting this button in Oracle SQL Developer: But But, you need to make sure of the following: You have compiled for debug You have the privs You have a breakpoint set OR you have set the debugger preferences to start with a ‘Step Over’ On Database 12c, […]

Similar Posts by Subject Areas: ,

Using DEBUG Mode in Oracle SQL Developer to Log SQL

Curious how we’re getting the data you see in SQL Developer when you click on something? While many of the dialogs provide a ‘SQL’ panel that shows you the SQL ABOUT to be generated, I’d rather see the SQL AS it’s executed. True, you could set a TRACE or fire up a Monitor Sessions report, […]

Similar Posts by Subject Areas: , , ,

Inspecting PL/SQL Collections with Oracle SQL Developer

Our stored procedures often capture information and store that data as a string or number. But sometimes we need to process more than just a single value. PL/SQL allows you to do this via collections. Now, if you’re looking for help getting started with collections, I would start with Using PL/SQL Collections and Records Oracle […]

Similar Posts by Subject Areas: , , ,

How to Collect Debug Info for Oracle SQL Developer

In a perfect world, there would be no software bugs. Developers would always test their code. QA would find any scenarios and bugs the developers hadn’t already thought of. Regression tests would be complete and flawless. But alas, we can only afford to pay mere humans here, so we will have bugs from time to […]

Similar Posts by Subject Areas: , , ,

Using SQL Developer to Debug your Anonymous PL/SQL Blocks

Everyone knows that SQL Developer has a PL/SQL debugger – check! Everyone also knows that it’s only setup for debugging standalone PL/SQL objects like Functions, Procedures, and Packages, right? – NO! SQL Developer can also debug your Stored Java Procedures AND it can debug your standalone PLSQL blocks. These bits of PLSQL which do not […]

Similar Posts by Subject Areas: , , ,

Using Pass Counts to Turbo Charge Your PL/SQL Breakpoints

Debugging PLSQL is one of the primary features of Oracle SQL Developer. Yes, its the IDE for the database, but PLSQL is the database’s programming language. It really, really needs to support all things PLSQL. Programming languages need modern day amenities if they are to be adopted by mainstream developers. One of those amenities is […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,