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;

Comments

Popular posts from this blog

Deleting the Sourcing Rule Assignments API

BarCode with XML Publisher