java 调用 oracle 存储过程 返回 结果集 ,Record ,cursor ..docx

Java调用oracle 存储过程返回结果集（record）首先创建2个type类型, ,我可以把record记录集里的内容赋给type对象类型，在给游标返回！假如环境是在scott/tiger用户下创建type定义你要返回的字段！drop typemyScalarType；drop type myTableType;createorreplacetype myScalarType asobject (rno number(18),rname number(18),rsal number(18));createorreplacetype myTableType astableof myScalarType;创建PACKAGECREATEORREPLACEPACKAGE TESTPACKAGE AStype type_cursor isrefcursor;end TESTPACKAGE;创建PROCEDURECREATEORREPLACEPROCEDURE test_items(MyTable out TESTPACKAGE.type_cursor)ISBEGINDeclareType RecType IsRecord ( rno number(18), rname number(18), rsal number(18) );Type TabType IsTableOf RecType IndexByBinary_Integer; MyTab TabType; obj_type_tab MYTABLETYPE := MYTABLETYPE(); vN Number;Begin--填充你要组装的字段 vN := 1; MyTab(vN).rno := 00000; MyTab(vN).rname := 11111; MyTab(vN).rsal := 22222; vN := vN + 1; MyTab(vN).rno := 33333; MyTab(vN).rname := 44444; MyTab(vN).rsal := 55555; vN := MyTab.First;For varR In vN..MyTab.countLoop obj_type_tab.EXTEND; obj_type_tab(obj_type_tab.LAST) := myscalartype(MyTab(vN).rno, MyTab(vN).rname,MyTab(vN).rsal); DBMS_OUTPUT.PUT_LINE(vN ||-- ||MyTab(vN).rno||--||MyTab(vN).rname||--||MyTab(vN).rsal); vN := MyTab.Next(vN);EndLoop; --*/open MyTable forselect rno ,rname,rsal fromtable(cast (obj_type_tab AS MYTABLETYPE));End; dbms_output.PUT_LINE(-dayi--);END test_items;Java 代码package test.samo.owner;import java.sql.*; import java.sql.ResultSet; import oracle.jdbc.driver.*; publicclass TestProcedureTHREE {/** * @param args */publicstaticvoid main(String[] args) {String driver=oracle.jdbc.driver.OracleDriver; String strUrl=jdbc:oracle:thin:@192.168.1.1:1521:orcl;Statement stmt=null;ResultSet rs=null;Connection conn=null;try{Class.forName(driver); conn = DriverManager.getConnection(strUrl, admin, 123456); CallableStatement proc = null; proc = conn.prepareCall({ call test_items(?) });proc.registerOutParameter(1,/*oracle.jdbc.*/OracleTypes.CURSOR); proc.execute(); rs = (ResultSet)proc.getObject(