我有一个存储过程,其声明如下:
PROCEDURE SALES
(
chv_OrgLevelNo IN VARCHAR2 := '0001',
chv_Sales_CD IN VARCHAR2 := NULL,
chv_Consigner_CD IN VARCHAR2 := NULL,
chv_StartDate IN VARCHAR2 := '20001010',
chv_EndDate IN VARCHAR2 := '20101010',
int_PerPageCount IN INTEGER := 10,
int_CurrentPage IN INTEGER := 1,
chv_sysErrMsg OUT VARCHAR2,
int_ReturnCode OUT INTEGER,
cur_Output OUT SYS_REFCURSOR
)我该如何用java调用存储过程并返回输出结果,
希望能提供源码,先谢谢了!
PROCEDURE SALES
(
chv_OrgLevelNo IN VARCHAR2 := '0001',
chv_Sales_CD IN VARCHAR2 := NULL,
chv_Consigner_CD IN VARCHAR2 := NULL,
chv_StartDate IN VARCHAR2 := '20001010',
chv_EndDate IN VARCHAR2 := '20101010',
int_PerPageCount IN INTEGER := 10,
int_CurrentPage IN INTEGER := 1,
chv_sysErrMsg OUT VARCHAR2,
int_ReturnCode OUT INTEGER,
cur_Output OUT SYS_REFCURSOR
)我该如何用java调用存储过程并返回输出结果,
希望能提供源码,先谢谢了!
.prepareCall("{call SALES (?,?,?,?,?,?,?,?,?,?)}");
func.setString(1, "");
.........
func.registerOutParameter(8, Types.VARCHAR);
.........func.execute();
String result8 = func.getString(8);