Pass multiple values to a single parameter in PL/SQL
Pass multiple values to a single parameter in PL/SQL
CREATE or REPLACE PROCEDURE XX_SAMPLE_TEST(P_ITEM varchar2)
is
i number;
l_length number;
r number;
l_count number;
l_item varchar2(50);
BEGIN
l_length := length(P_ITEM);
i := 1;
r := 1;
WHILE (i < l_length)
LOOP
l_count := (INSTR(P_ITEM,',',1,r)-i);
IF l_count < 0 THEN
l_count := l_length;
END IF;
SELECT substr(P_VALUE,i,l_count) INTO l_item FROM dual;
dbms_output.put_line(l_item);
i := i + length(l_item)+1;
r := r+1;
END LOOP;
END;
CREATE or REPLACE PROCEDURE XX_SAMPLE_TEST(P_ITEM varchar2)
is
i number;
l_length number;
r number;
l_count number;
l_item varchar2(50);
BEGIN
l_length := length(P_ITEM);
i := 1;
r := 1;
WHILE (i < l_length)
LOOP
l_count := (INSTR(P_ITEM,',',1,r)-i);
IF l_count < 0 THEN
l_count := l_length;
END IF;
SELECT substr(P_VALUE,i,l_count) INTO l_item FROM dual;
dbms_output.put_line(l_item);
i := i + length(l_item)+1;
r := r+1;
END LOOP;
END;
Comments
Post a Comment