Multiple values as Input Parameter
948938Jul 12 2012 — edited Jul 12 2012Hi All,
I need some help on how to implement
Create or replace Pr( p_id in varchar2)
is
begin
select empname from emp where empid = p_id;
end;
/
The above will work fine if i pass one value how to handle if i want to pass multiple id's (comma seperated or tab ).
I tried it with dbms_utility.COMMA_TO_TABLE the output is not consistant.
Can some one please give inputs
Thanks