[Bug]: When running the stored procedure, "Missing IN or OUT parameter in index::3" is reported.

[Huangxiao-mas]

ODC version

ODC4.2.1

OB version

oceanbase2277

What happened?

When running the stored procedure, "Missing IN or OUT parameter in index::3" is reported.

What did you expect to happen?

Execute normally

How can we reproduce it (as minimally and precisely as possible)?

CREATE TABLE "EVENT_FLOW_LOG_SOURFILE" (
  "OID" VARCHAR2(64),
  "MODULE_ID" NUMBER(4),
  "FLOW_ID" NUMBER(4),
  "FLOW_TIME" DATE,
  "SOURCE_NAME" VARCHAR2(64),
  "FILE_EVENT_COUNT" NUMBER(9),
  "STORE_TYPE" CHAR(1),
  "STORE_NAME" VARCHAR2(64),
  "ENTRY_MODULE_ID" NUMBER(4),
  "SOURCE_HASH" NUMBER(2) DEFAULT 0
) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
 partition by range("FLOW_TIME")
(partition P_MAX values less than (TO_DATE('2037-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')));

create or replace PROCEDURE process_result_set IS
    CURSOR cur IS SELECT "OID" FROM EVENT_FLOW_LOG_SOURFILE WHERE "OID" IS NOT NULL;
    result_val EVENT_FLOW_LOG_SOURFILE.OID%TYPE;
BEGIN
    FOR rec IN cur LOOP
        result_val := rec.OID;
        
        -- 对结果进行处理
		INSERT INTO EVENT_FLOW_LOG_SOURFILE ("OID") VALUES (result_val);
        -- ...
    END LOOP;
    
    DBMS_OUTPUT.PUT_LINE('Result set processed');
END;

Anything else we need to know?

No response

Cloud

No response

[yhilmare]

can not reproduce it:

[Huangxiao-mas]

able to reproduce by

create or replace PROCEDURE P_CISP2_CMS_ETL_TRD_DETAIL(P_OUT_FLAG   OUT VARCHAR2,
P_OUT_MSG    OUT VARCHAR2,
P_OUT_RESULT OUT VARCHAR2)
AS
V_QCRQ        VARCHAR2(8); --期初日期
V_QMRQ        VARCHAR2(8); --期末日期
V_QMJYR       VARCHAR2(8); --期末最后一个工作日
V_PERIOD      VARCHAR2(8); --报告期 YYYYMM
V_LAST_PERIOD VARCHAR2(8); --上次报告期
V_NCRQ        VARCHAR2(8); --年初日期
BEGIN
dbms_output.put_line(1 / 1);
COMMIT;
dbms_output.put_line(1 / 1);
END;

[Huangxiao-mas]

change the OB version ,it displays normally