Hi,
We came across a problem today with the Stored Procedures for reports.. Was nothing major - but the thing that came to light was there is a large growing list of stored procedures, and its not easy to see the difference between them - sometimes there is only one letter (ie a plural S) between different Stored Procs.
My suggestion is to create a naming convention that makes it obvious which SP's are used for reporting, which are used for internal Jiwa use - and which are actually sub-stored procedures - ie called by other Stored Procs and not used in their own right.
Thanks