Understanding Distinct Queries with Oracle in Depth

Understanding Index-Organized Tables (IOTs) in Oracle: A Comprehensive Guide to Creating and Managing IOTs

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

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