|visits||member for||2 years, 3 months|
|seen||Oct 8 '14 at 4:06|
Established coding standards for pl/pgsql code
Not a complete answer, but definitely create error messaging (using ORA error messaging or logging of other error info to a file or table) that spits out section numbers within functions/procedures to track down failures. Nothing worse than debugging a 400 line procedure that has nothing to narrow down where the error occurred.