Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL coding verification tool (
PL/SQL coding verification tool [message #402922] Wed, 13 May 2009 03:00 Go to next message
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 #402925 is a reply to message #402922] Wed, 13 May 2009 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 65138
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is none.

Re: PL/SQL coding verification tool [message #402939 is a reply to message #402925] Wed, 13 May 2009 04:24 Go to previous message
Messages: 3202
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.
Previous Topic: HOw to find out the procedure/Function/Package parmater having default vlaue used
Next Topic: SQL Query to Update and retrieve the records
Goto Forum:

Current Time: Thu Aug 17 16:27:16 CDT 2017

Total time taken to generate the page: 0.17891 seconds