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(...