I want to use PL/SQL functions to add business logic / modifications to a set of results. Rather than return just one value from an Oracle Procedure, can I use Oracle collections and objects(Specially using IS TABLE OF ) to return a set of results back to
Java ?
I'm using Oracle 9i - and I've been fishing around at lots of documentation - but haven't found any magic answers yet.
i am facing error sqltype 2003 error
Would appreciate any advice....
Plz.........