SQL> desc test
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                                 NUMBER(38)
 NAME                                               VARCHAR2(10)

SQL> select * from test;

        ID NAME
---------- ----------
         1 asd
         3 sdf
  
SQL> select text from all_source where type='FUNCTION' and
  2  name = 'RETURN_REF';

TEXT
--------------------------------------------------------------------------------
function return_ref
return sys_refcursor
is
a sys_refcursor;
begin
open a for select * from test;
return a;
end;

JSP代码：
<%@   page   contentType= "text/html;charset=gb2312"%>  
<%@   page   import= "java.sql.* "   %>   
<%@   page   import= "java.io.* "%>
<%@   page   import="oracle.jdbc.driver.* "%>

<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@10.201.1.134:1521:orcl";
//myoracle为SID(数据库的名称)
String userr="scott";
String passwordd="tiger";
Connection conn= DriverManager.getConnection(url,userr,passwordd);
ResultSet rs=null;
oracle.jdbc.OracleCallableStatement     call   =   null;

CallableStatement cs;
try{
    call   =   (oracle.jdbc.OracleCallableStatement)conn.prepareCall("{? =call return_ref}");
 call.registerOutParameter(1,oracle.jdbc.OracleTypes.CURSOR);
 call.executeQuery();
    rs   =   (ResultSet)call.getCursor(1);
 while(rs.next()){  
        out.println(rs.getString(2));  
     }  
}
 catch (SQLException e) {out.print(e);
    }
%>