Register the out-parameter of your procedure as an OracleTypes.CURSOR


e.g.

            cs = Conn.prepareCall("{call pkgzwTest.P_zwTest(?)}");
            cs.registerOutParameter(1,OracleTypes.CURSOR);
            cs.execute();
            rs = (ResultSet)cs.getObject(1);

you can get more details from
http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/basic/RefcursorS
ample/RefcursorSample.java.html
or download the java/oracle developers manual from
http://otn.oracle.com/tech/java/sqlj_jdbc/pdf/a96654.pdf

hope this helps



----- Original Message -----
From: "billczwen" <billczwen@e...>
To: "Servlets" <servlets@p...>
Sent: Monday, October 28, 2002 10:18 AM
Subject: [servlets] java how to invok oracle packeages which return a
RecordSet?


> java how to invok oracle packeages which return a RecordSet?
>
> packeage is
>
> create or replace package pkgzwTest is
> TYPE myrctype IS REF CURSOR;
>
> procedure P_zwTest(o_RecordSet OUT myrctype);
> end pkgzwTest;
> create or replace package body pkgzwTest is
> procedure P_zwTest(o_RecordSet OUT myrctype)
> as
> begin
> open o_RecordSet for
> select custname,summary from custinfo;
> return;
> end P_zwTest;
> end pkgzwTest;
>
>
>
> how to return all of the record?
>