scripts for checking naming conventions (prefix etc) for PL/SQL

  • From: "Bjørn D. Jensen" <bjorn.d.jensen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 21 Sep 2007 15:57:05 +0200

Hi!
I'm looking for scripts that can validate PL/SQL code against
some business coding style rules.

Checking that procedure start with
insert/update/delete/check

that schema-prefix is used,
that procedures not are too long
and other nice things to check.
I read about it somewhere, but I can't remember where I read it.

The scripts are not so important, it's more important for me to get some
ideas about
what could be of value to check.
Thaks for help!
Bjorn

Other related posts: