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: 63923
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: 3186
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: Wed Oct 26 00:55:36 CDT 2016

Total time taken to generate the page: 0.08547 seconds