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.
Printable View
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.
use dbms_output.put_line
Thats all you need for your debugging
Yes, but i would like to rectify the bugs when i write the code.
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
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.
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...
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....
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...
Less expensive than free? A community download of TOAD is available for free from:Quote:
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.
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
Yes... if you download PL/SQL Developer they send you a check for $100! Just joking (I couldn't resist).Quote:
Originally posted by TimHall
Less expensive than free?
Tim, your website has saved my butt 50 times - THANKS!