PL/SQL code review tool [message #176708] |
Fri, 09 June 2006 04:30 |
kumarsz
Messages: 180 Registered: March 2005 Location: canada
|
Senior Member |
|
|
Hi,
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.
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
|
|
|
|
Re: PL/SQL code review tool [message #176750 is a reply to message #176722] |
Fri, 09 June 2006 07:29 |
kumarsz
Messages: 180 Registered: March 2005 Location: canada
|
Senior Member |
|
|
Hi Mahesh,
Is "Oracle Tuning advisor " specific to 10g?
We are using "Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production" on Linux environment.
Thanks and Regards,
Pratap
|
|
|