CREATE OR REPLACE FUNCTION GetAPPids (bill_no int,str varchar2) 
RETURN appids TABLE(bill_number int, appointment_id int) AS
     @appid int;
     @delimeter int; 
     @beginid int;
     @cnt int;
BEGIN
     cnt:=1;
     beginid=1;
     delimeter:= INSTR(STR,CNT,',');
     WHILE @delimeter>0 LOOP
     BEGIN
		appid := substr(str,beginid,delimeter-1);
		INSERT INTO appids values(bill_no,appid);
		delimeter := INSTR( str, beginid,',');
		beginid   := delimeter+1;
     END;
     END LOOP;
     RETURN appids;
END;
/