是直接返回的游标，不是用游标参数返回，用数据库查询数据集，这么调用存储过程，call DBUSER.P_RPT('${IN_DATE}','${P_ORG_ID}',?,?)，会报错 存储过程调用游标的内容如下：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; |
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
