SQL> get din
  1  -- dinesh this may helpyou...change it accordingly.
  2  -- usage : sp_emails('string','separator')
  3  create or replace
  4  PROCEDURE sp_emails
  5  (
  6       v_in varchar2,
  7       v_te varchar2
  8  )
  9  as
 10  a   VARCHAR2 (1);
 11  b   VARCHAR2 (30);           -- max length of a single email id..increase it as ur need
 12  i   NUMBER;
 13  str varchar2(300);           -- max value of arrays as input..increase it as ur need
 14  cnt number;
 15  BEGIN
 16  i:=1;
 17  str:=v_in||v_te;
 18  FOR mag IN 1..length(str) LOOP
 19       a:=substr(str,i,1);
 20       IF a=v_te THEN
 21               i:=i+1;
 22  --              DBMS_OUTPUT.PUT_LINE (b);       -- for debugging..remove later
 23        ELSE
 24               b:=b||' '||a;
 25               i:=i+1;
 26       END IF;
 27       END loop;
 28  dbms_output.put_line(b);   -- for debugging..remove later or create an OUT paramter
 29* END;
SQL> /

Procedure created.

SQL> begin
  2      sp_emails('1:4:5',':');
  3  end;
  4  /
1 4 5

PL/SQL procedure successfully completed.

SQL> begin
  2      sp_emails('1;4;5',';');
  3  end;
  4  /
1 4 5

PL/SQL procedure successfully completed.

SQL>  begin
  2       sp_emails('1*4*5','*');
  3   end;
  4  /
1 4 5

PL/SQL procedure successfully completed.