Oracle Stored Procedure

[Booma Devi]

Hi,

I am new to oracle stored procedure. I want to know how to pass the list of values ('A','B','C') to oracle stored procedure..?

I used the IN clause (IN(@namedList)) in my procedure. please send me any sample for this...

Thanks in advance...

[karthick meyyappan]

check it out.,
http://docs.oracle.com/cd/B12037_01/appdev.101/b10795/adfns_pc.htm

PROCEDURE Get_emp_names (Dept_num IN NUMBER) IS
   Emp_name       VARCHAR2(10);
   CURSOR         c1 (Depno NUMBER) IS
                     SELECT Ename FROM Emp_tab
                        WHERE deptno = Depno;
BEGIN
   OPEN c1(Dept_num);
   LOOP
      FETCH c1 INTO Emp_name;
      EXIT WHEN C1%NOTFOUND;
      DBMS_OUTPUT.PUT_LINE(Emp_name);
   END LOOP;
   CLOSE c1;
END;