Using Arrays in Stored Procedures with SOA Oracle: A Step-by-Step Guide

Understanding Oracle's Aggregate Function Ordering Behavior: When Average Goes Wrong with Group By Clauses

I can help with some of the issues you're facing.