| PL/SQL coding verification tool [message #402922] |
Wed, 13 May 2009 03:00  |
user71408
Messages: 585 Registered: November 2007 Location: NE
|
Senior Member |
|
|
Hi All,
We have many packages in our project(which are written in earlier). Now we are going to verify the package for following aspects of the code:
- Syntax
- Cursor usage (opening/closing cursors)
- Performance improvement
- Optimizing the code etc
so we are going to add commnets at the modification required points. Can any one please let me know is there any tool to complte this .Please suggest any tool for this.
Thank you
|
|
|
|
|
|
| Re: PL/SQL coding verification tool [message #402939 is a reply to message #402925] |
Wed, 13 May 2009 04:24  |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Of course, regarding the syntax, there is this fine tool called "Oracle", which does a very nice syntax check every time you try to compile a package/procedure/function, and doesn't let you do it if the syntax isn't right.
|
|
|
|