Hi Experts,
Need some ideas/pointers regarding some '
code check/syntax validation ' tool.
Is there any way - to create a PL/SQL proc (say 'X') where the i/p will be any Table creation or Procedure script. X will check for the syntax validations and any other coding loop-holes.
Actually we have a lot of overhead of manual checking the code for some coding best practices. So just want to automate them in a proc X.
May be writing
Regexs or any other way... some checks like -
+1]+ CREATE or REPLACE PROCEDURE <schema_name>.<proc_name>
Usually developers over here avoid the schema name.
+2]+ Proper Exception Blocks with no WHEN OTHERS THEN NULL;
Is this actually feasible or I'm just over-thinking?
(I've access to both 10g and 11g databases.)
Please suggest some ideas. (as of now, I'm trying for a windows Batch script which will check for the validation for scripts stored in a folder as +.txt+ )
Help much appreciated.
Ranit B.