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 [...]
debug
SQL Developer Tip: Viewing REFCURSOR Output
If you work with PL/SQL, then this feature might be the #1 reason I recommend you immediately upgrade to at least version 3.0 of Oracle SQL Developer – SQL Developer now automatically renders SYS.REFCURSOR output from your PL/SQL calls. Prior to version 3.0, you needed to use the SQL*PLUS PRINT command to view the refcursor [...]
The PL/SQL Debugger Strikes Back: Episode V
I’ve already discussed how the Rebel scum go about figuring out what’s wrong with their code. Now I want to get into the nitty-gritty details of how to start a debug session in SQL Developer. There are some prerequisites, but I promise it won’t take but a few moments to setup. Ensure that you have [...]
Debugging PL/SQL with SQL Developer: Episode IV
Can you tell us more about the debugger? Can you show us the debugger? What about the debugger? Can you spell ‘debugger’? Why can’t the debugger show X? What is COMPILE WITH DEBUG anyway? Debugger? Skip to Episode V – Starting the Debugger In the past 10 years I have probably heard these questions and [...]
Watching Paint Dry or V$SQLTEXT_WITH_NEWLINES
How much time to do you spend debugging database application problems? Probably more time than you want. How much of that time is spent capturing the SQL that is being submitted by your application to the database? I’m going to guess that it’s a significant amount. Asssuming you have access to production (or a test [...]
1 2
Twitter
RSS
GooglePlus
Facebook