Paul,
Our applicationsdo database access
solely though packaged pl/sql calls which return a ref cursor. Some use
OCI, others JDBC. Experience has been very
positive. Administrative advantages in having such an "abstraction layer"
between apps and the database are manifold As a DBA, you
On my previous gig all DB access was via
stored procedures returning ref cursors through JDBC. The Java dweebs could do
just about anything with the ref cursor. It worked really well. I could actually
tune SQL queries on the running production application without any
recompilation. Nice
Paul,
For acouple of projects that I've
worked on, several Java programmers have liked having Ref Cursors returned from
PL/SQL stored procedures. They could work with those much more easily than
PL/SQL tables.
Can't remember if we even tried VArrays. I
don't think I'd like them for
I was about to write a similar testimonial when I saw
Steve Orr's message. Don't use OCI based class111.zip.
It has Oracle properity classes. The pure java
class111.zip works great and is portable. Passing ref
cursors from stored procedures makes the solution
simple and elegent to implement.