Passing data to Java: Ref Cursor vs Collections
612987Apr 22 2008 — edited Apr 23 2008Hi,
I'm working on a three layer application that has the entire logic in the PL/SQL.
We use JPublisher to publish the PL/SQL in the middle tear (Tomcat).
Actually the data is passed from the database (10g) to the java with Ref Cursors.
Although this method works very well, it brings some disadvantages as I can't "see" the data inside the cursor before I send it to the Java.
I was thinking if I it is possible to use collections to pass the data to the Java.
Bulk collect could be used and all the other operations available for the collections. It would be also more modular. Does this makes any sense?
How does the JPublisher deals with collections? Is it possible to generate the serialization methods for collections?
If anyone could elaborate on this I would appreciate very much.
Thank you,
Vasco Rocha