是直接返回的游标,不是用游标参数返回,用数据库查询数据集,这么调用存储过程,call DBUSER.P_RPT('${IN_DATE}','${P_ORG_ID}',?,?),会报错
48102存储过程调用游标的内容如下:
CREATE OR REPLACE PROCEDURE DBUSER.P_RPT (
IN IN_DATE CHARACTER(6),
IN P_ORG_ID VARCHAR(18),
OUT OUT_SQLCODE INTEGER,
OUT OUT_MSG VARCHAR(512) )
SPECIFIC "P_RPT_DEP_LOAN_STAT_LVL1"
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
MODIFIES SQL DATA
CALLED ON NULL INPUT
INHERIT SPECIAL REGISTERS
OLD SAVEPOINT LEVEL
BEGIN
。。。。。。。。。。。。
P1:BEGIN
DECLARE C1 CURSOR WITH RETURN TO CALLER FOR
SELECT
DATA_DT ,
LVL2_NO ,
LVL2_NAME ,
LOAN_INTREST_INCOME ,
LOAN_DAVG,
LOAN_PERCENT,
LAST_LOAN_INTREST_INCOME ,
LAST_LOAN_DAVG,
LAST_LOAN_PERCENT,
DEP_INTREST_INCOME,
DEP_DAVG,
DEP_PERCENT,
LAST_DEP_INTREST_INCOME,
LAST_DEP_DAVG,
LAST_DEP_PERCENT
FROM SESSION.TMP_DEP_LOAN_STAT_LVL1;
OPEN C1;
END P1;
。。。。。。。。。。。。
END;