Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    4

    Unanswered: Oracle PL/SQL Code Review Tool

    Hi,
    We are using Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production on Linux
    we are in a need of a Tool which will help us review PL/SQL routines (Procedures, Functions, Packages).
    The main purposes of reviwing above things are
    1) If Standards are followed in the code
    e.g. caller procedure is missing Exception handling while calling another procedure etc.
    2) Performance related issues are handled in the code
    e.g. using Exists instaed on IN operator wherever possible etc.

    Please note that above are just examples. However intention is Senior member should be able to review and catch logical mistakes, if any made by junior members.

    I have used Formatter Plus tool in TOAD, however it does not cover such things.
    Please suggest a tool which covers (and handles such issues)

    Thanks and Regards,
    Pratap

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Hmmm...there are very few hard and fast rules with performance tuning, dont assume exists is always better than an in clause. Instead it would be better if you put profiling code in so when a procedure takes a longer than expected you are alerted to it and then you can tune it.

    Alan

  3. #3
    Join Date
    Jan 2012
    Posts
    1
    Hi Pratap...
    even i have the same requirement as yous..
    were you able to find the soluation?

    please reply back to mansavs@gmail.com

  4. #4
    Join Date
    Apr 2012
    Posts
    1
    Hi,
    There is a useful tool for plsql code review from TOAD.
    Tool name is code expert.

    This may not fulfill your requirements 100%, but defenitely helpful. Try any trail version (if available) before actually buying it.

    Regards,
    Rajesh

Posting Permissions

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