JavaSp ResultSet to PL/SQL REF CURSOR

[b...@haus.com]

All,

I have an application that uses VB COM objects to call PL/SQL Sps on
an Oracle 8i database on Solaris. The need to do some more complex
operations has arrived and we want to use JavaSps to do the work.

My question is: How do I pass a ResultSet from the JavaSp back to the
PL/SQL wrapper for it into a REF Cursor? The COM object calls a
PL/SQL SP with a defined REF CURSOR as an IN OUT parameter. How do I
map the ResultSet from the JavaSP to the REF Cursor that is the IN OUT
parameter? I'll be damned if I can find an example of that in the
Oracle JavaSp Documentation anywhere.

Thanks in Advance,
Jim Skentzos
jske...@lucent.com