DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: PL SQL Debug tool

  1. #1
    Join Date
    Jun 2003
    Posts
    108

    PL SQL Debug tool

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    use dbms_output.put_line

    Thats all you need for your debugging

  3. #3
    Join Date
    Jun 2003
    Posts
    108
    Yes, but i would like to rectify the bugs when i write the code.

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  5. #5
    Join Date
    Jun 2003
    Posts
    108
    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.

  6. #6
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  7. #7
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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....

  8. #8
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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...
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  9. #9
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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
    Last edited by TimHall; 09-10-2003 at 04:05 AM.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  10. #10
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width