Pl/SQL Debugging Tools 2009 (Oracle)

I love TOAD, however with windows server 2003 and Oracle 9i or 11g, we are having some challenges getting the debugging environment to work.
I see there are a few topics here on various tools to create a GUI debugging environment, however, some of the messages are a bit old.

What tools are currently available for a GUI debugging environment and how do you feel about them?
GNOVAKAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ytarkanConnect With a Mentor Commented:
I can recommend PLSQL Developer from  www.allroundautomations.com its a very convinient tool with many abilities including just in time debugging. On the other hand  Oracle SQL Develeoper tool is also a good debugger and freely downloadable from technet.oracle.com address.
0
 
DavidSenior Oracle Database AdministratorCommented:
This doesn't address your specifc question, but what are the debugging issues? Between EE and TOADWORLD, that shouldn't remain a stumbling block for long.
0
 
GNOVAKAuthor Commented:
Long story, and I would love to have TOAD debugger working, however, only 2 of 5 machines running Windows Server 2003 R2 on DELL PowerEdge servers work with debug. The other 3 give a PROBE:TIMEOUT error and/or an OCI.DLL access violation error.
Of the 3 machines not working - 1 is runing 9.7 TOAD with a local instance of Oracle, 1 is running Client (TOAD9.5) and a brand new machine is running local also(TOAD9.5) All are accessing a server running 11g.
We cant afford to have debug not working on all machines. The current workaround is to log into one of the machines that are working and debug from there. Not really a long term viable solution.
So I'm looking to see what alternatives exist.
If, in the meantime, you have an idea on the TOAD issue, I sure would be interested.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
GNOVAKAuthor Commented:
No one has any comments on PL/SQL debuggers?

I can't believe you're all using either TOAD or the manual SQL Plus method....
0
 
Geert GruwezOracle dbaCommented:
there is different licenses for toad, one is with debug, other not
it took as a while to figure it out, but with the license it should say if debugging is enabled
0
 
gatorvipCommented:
>>Of the 3 machines not working - 1 is runing 9.7 TOAD with a local instance of Oracle, 1 is running Client (TOAD9.5) and a brand new machine is running local also(TOAD9.5) All are accessing a server running 11g.

I have no experience with TOAD, but this (combined with the OCI.dll error) leads me to suspect that you have conflicts between multiple version of Oracle oci.dlls .
0
 
GNOVAKAuthor Commented:
what debuggers for PLSQL are you using?
0
 
GNOVAKAuthor Commented:
anyone have experience with the Oracle tool?
How does it compare?
0
 
gatorvipConnect With a Mentor Commented:
I use SQLDev extensively but do very little debugging with it. It's a very good tool, imo. It's free so you can just download it ( http://www.oracle.com/technology/software/products/sql/index.html ) and see if it suits your needs
0
 
GNOVAKAuthor Commented:
Thanks all.

Ok - so there's TOAD, Oracle SQLDev, and PLSQL Developer.
Anyone else using something different?
0
All Courses

From novice to tech pro — start learning today.