PL SQL Debug tool

[sri_dba]

Hi All,

Can anyone let me know the site to download(free one)PL SQL debug tool.

I would be very happy if i get this tool. Bcoz i am struggling to rectify the bugs in normal text pad.

Thanx in advance.

[davey23uk]

use dbms_output.put_line

Thats all you need for your debugging

[sri_dba]

Yes, but i would like to rectify the bugs when i write the code.

[TimHall]

Hi.

Try: http://www.toadsoft.com

It's the freeware version of TOAD. It's not got all the features but it's good enough.

Cheers

[sri_dba]

Thanx a lot.

I downloaded and i could not connect with DB.

The following error shows.

Error while trying to retrieve text for error ORA-12154

Details:
Building Oracle HOMES List
HOME Name OraHome81 added to list.
HOME Name oem added to list.
Found multiple homes, searching each HOMEx for valid PATH
searching in SOFTWARE\ORACLE\HOME1
Oracle_Home found in SOFTWARE\ORACLE\HOME1 IS in system path!
searching in SOFTWARE\ORACLE\HOME0
Using: C:\oem\bin\ORA804.DLL

What could be the problem.

[TimHall]

Hi.

Like most non-java Oracle tools it relies on the Oracel client installation on your machine to make conenctions. Once you have a valid Oracle client loaded it should be fine.

Cheers

Tim...

[gopi]

I've been using PL/SQL Developer for 4 years - it is a grrreat tool and is way, way, way less expensive than Toad.

The debugger is fantastic! Step through code one line at a time, jump over statements, show the values of variables, suspend the run and restart, etc....

Easy, easy, easy use of Profiler and Explain plan....

[Tarry]

I am beginning to get inclined towards TOAD, I've used pl/sql developer(still do) but am always tempted to open the TOAD. Guess I like the "croak"...

Both these tools are excellent tools for developers...

[TimHall]

Originally posted by gopi
I've been using PL/SQL Developer for 4 years - it is a grrreat tool and is way, way, way less expensive than Toad.

Less expensive than free? A community download of TOAD is available for free from:

http://www.toadsoft.com

You will need to redownload it every 90 days.

This is not a crack or dodgy copy, it is an official release and provided less than 5 people in your company use it there are no license issues.

The free version does not have a full PL/SQL debugger, but it will allow you to do most things the full product can do.

Cheers

[gopi]

Originally posted by TimHall
Less expensive than free?

Yes... if you download PL/SQL Developer they send you a check for $100! Just joking (I couldn't resist).

Tim, your website has saved my butt 50 times - THANKS!