java审查oracle存储过程返回记录集-数据库教程-爱易网页

java审查oracle存储过程返回记录集

日期：2014-05-16　浏览次数：20531 次

java调研oracle存储过程返回记录集

PACKAGE

sql 代码

CREATE?OR?REPLACE?PACKAGE?PKG_UIREPORT_DEPTTRANSTABLE??AS??

??

?TYPE?MY_CURSOR?IS?REF?CURSOR; ??

??

end?PKG_UIREPORT_DEPTTRANSTABLE;??

PROCEDURE

sql 代码

CREATE?OR?REPLACE?PROCEDURE?GETDEPTTRANSTABLE(??? ??
???????o_CURSOR?out?PKG_UIREPORT_DEPTTRANSTABLE.MY_CURSOR,??? ??
???????i_POST_DATE?IN?VARCHAR2,??--传入参数1?? ??
???????i_SEC_TYPE?IN?VARCHAR2??????--传入参数2?? ??
???????)?IS??? ??
?? ??
BEGIN??? ??
????OPEN?o_CURSOR?FOR?select?*?from?sec_vou?T1?WHERE?T1.CLEAR_DATE?=?i_POST_DATE?AND?T1.SEC_CODE?IN?(select?T2.SEC_CODE?from?ea_pub.sys_sec_info?T2?WHERE?T2.SEC_TYPE?=?i_SEC_TYPE);??? ??
?? ??
END?GETDEPTTRANSTABLE;????