Java is a good tool to do prototyping

when it comes to production, it is not fast enough.

Cognos 8 doesn't support ORACLE REF CURSOR

So to get around with this, use wrapper function and PIPELINED table.