A multi-ID that is passed over in Oracle needs to be inserted into the database, and the stored procedure is split.

Create or replace procedure test
(
jf_id in Nvarchar2,
yf_id in Nvarchar2
)

As

V_length Number: = Length (yf_id);
V_start number: = 1;
V_index number;

Begin

while (V_start <= v_length)
LOOP
V_index: = INSTR (yf_id, ', ', v_start);

IF V_index = 0
Then
Dbms_output.put_line (SUBSTR (yf_id, V_start));
V_start: = v_length + 1;
ELSE
Dbms_output.put_line (SUBSTR (yf_id, V_start, V_index-v_start));
V_start: = V_index + 1;
END IF;
END LOOP;

Exception

When others then

Rollback;

End;

A multi-ID that is passed over in Oracle needs to be inserted into the database, and the stored procedure is split.