Combine the output of 2 cursors

just try the following method tow combine the two tables. its very simple method instead of creating two cursors.



ALTER TYPE SAMPLE_TYPE  AS OBJECT ( COL1
    NUMBER(6, 0), COL2 VARCHAR2(30));

CREATE TYPE SAMPLE_TABLETYPE AS
    TABLE OF SAMPLE_TYPE;




(
p_restcode    IN  REST_INFO.REST_CODE%type,
p_attdt       IN  DAILYATTENDANCELOG.CHECKTIME%type
)

RETURN SAMPLE_TABLETYPE PIPELINED AS
 r_mstabletype   SAMPLE_TYPE;
BEGIN
FOR r_count IN (SELECT A.ID,A.NAME,B.ADDRESS,B.CITY FROM TABLE1 A,TABLE 2 B WHERE A.ID=B.ID) LOOP

 r_mstabletype:=DAILYATTCOL(r_count.ID,r_count.NAME);

PIPE ROW(r_mstabletype);
END LOOP;
RETURN;
END ;