Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2002
    Posts
    27

    Unanswered: How to Best Develop PL/SQL scripts ?

    Given that my manager won't buy an add-on tool,
    what's the best way to develop PL/SQL scripts ?

    Right now I'm just writing anonymous blocks and viewing
    the error messages when they bomb.

    In 9i I don't see a "Stored Procedure Developer" tool included in OEM
    (am I missing something here?)

    Thank you for your advice.

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    I like TOAD but if your manager won't spend money I've heard of people having success with SqlTools. Apparently it has a similar interface etc and best of all it's free.

    http://www.sqltools.net/

    I haven't used it, and there are probably more out there.

    Hth
    Bill

  3. #3
    Join Date
    May 2003
    Posts
    87
    Are you allowed to download trial versions ? If yes, then there are couple of good tools. Billm already mentioned my all time favourite TOAD, which you can keep downloading every 30 days and keep using it.

    Check few more tools here :
    http://www.orafaq.net/tools/#DEVELOPER
    http://www.orafaq.net/links/Products/Freeware/
    http://www.orafaq.com/faqlink.htm#SHAREWARE

    And dont expect Oracle to develop some good tool -- what a pity that the company which has developed the world's best database does not have a single decent tool :-(

  4. #4
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208
    I would suggest TOAD. Its the best tool around in my opinion. You can get a freeware version from

    http://www.toadsoft.com/downld.html

    If you have Oracle Developer toolset you can use the Procedure Builder. If need by you can download a copy from Oracle.


    Originally posted by dbmadcap
    Are you allowed to download trial versions ? If yes, then there are couple of good tools. Billm already mentioned my all time favourite TOAD, which you can keep downloading every 30 days and keep using it.

    Check few more tools here :
    http://www.orafaq.net/tools/#DEVELOPER
    http://www.orafaq.net/links/Products/Freeware/
    http://www.orafaq.com/faqlink.htm#SHAREWARE

    And dont expect Oracle to develop some good tool -- what a pity that the company which has developed the world's best database does not have a single decent tool :-(

  5. #5
    Join Date
    Dec 2002
    Posts
    27
    Thank you all for excellent advice.

    One more option I found yesterday:
    utPLSQL, open source unit testing framework available
    for free at http://utplsql.sourceforge.net/
    and its newer GUI version, Ounit 1.0, available for free at
    http://www.ounit.com.

    Thanks, everyone.

  6. #6
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi Howardfci,

    I'm not so sure about OUnit - not because I've run it but because I just saw the installation screen. It wants SYSDBA priviledges to be installed.

    That's fair enough if it wants to create some objects or grant rights etc, but I'd rather it gave me the script so I can look first and then decide. I havent got time right now to create a 'throwaway' instance just to see what OUnit does to it.

    One of the nice things about TOAD is that it will connect to any schema/instance without affecting the instance - it adjusts it's behaviour to what it knows is possible. Ie, if you run (on TOAD v7+) the toadprep.sql connected as sys, you get a load more Toad functionality but if you don't run the script you don't but TOAD wil stil run - ie it's your choice. Most importantly you can read/consider toadprep.sql before you run it.

    I like TOAD (as you've probably guessed!) but I've felt for a long time that it's getting too heavy for a developer. They've tried to turn it into a be-all-and-end-all for every man and his dog, hence the d/l size (and it's occurrences of A/V's) is going up. As a result I've been thinking for some time now about developing a straightforward developer GUI for Oracle (funnily enough under Delphi/DOA just like OUnit). It would probably be what Toad was back at version 2 or something, and hence a 1Mb download, not a 12Mb download.

    I was thinking/hoping that is what OUnit had done, concentrated on developers with a small, tight program. I'm afraid though that they've failed at the first hurdle.

    Imagine I turn up on site and say to a customer "I want to run TOAD, it will do nothing to any schemas at all".

    Now imagine I turn up and say "I want to run OUnit and I haven't got a f***ing clue what it will do to your schemas".

    Yes, I could create an empty instance to install it on and find out, but then in that time I could d/l and install Toad which I know doesn't affect the schema's.

    It might not seem important now, but when you're turning up on site and they won't let you run Toad/Ounit/SqlTools etc and you're back to SqlPlus, you have to hope the available option is one that you're familiar with. I don't think at this moment in time that OUnit (in it's present form) is going to achieve enough popularity to be one of them.

    Cheers
    Bill

  7. #7
    Join Date
    Jun 2003
    Location
    Sydney, Australia
    Posts
    66
    >> getting too heavy for a developer
    >> I've been thinking for some time now about developing a
    >> straightforward developer GUI [ tool ]

    Me too. I believe there is a need for a "back-to-basics" tool. I'm a developer, so I don't have access to the management structures used by DBAs. And my DBA friends know their commands anyway, so they are not using the more esoteric features of DbArti$an.

    I'm willing to contribute my time to develop such a simple tool. I don't know Delphi, so I was considering Java-Jdbc-Swing for a while. The advantages would be access to both Windows and Unix, and also some multi-platform features ( i.e. one module for Oracle, another module for Sybase, etc). Does not sound like a big deal to develop, although we would never make money from it.

    Andrew Schonberger

Posting Permissions

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