Application Documentation for Oracle Objects

When your application developers write applications do you require any type of 
documentation as far as listing what packages are being called or maybe even 
more specific what procedures are being called in each part of your 
application?  And do any of you have this automatically collected via a log on 
trigger or part of the connection info, or even a separate log procedure?
Right now we have nothing and I would really like to know how and where all our 
pl/sql objects are being used.  We write a lot of custom applications for our 
company and share a lot of code/tables among applications.

Oh and on a side note, do your .Net developer or C++ or whaterver write their 
own pl/sql or do you have a dedicated team to do just pl/sql for your Windows 
developers?

Thanks for your input.

Jeff








Other related posts:

  • » Application Documentation for Oracle Objects - Jeff Chirco