CREATE TABLE hallo (ID number(10) PRIMARY KEY, NAME varchar2(255));
INSERT INTO hallo (ID, NAME) VALUES (1, 'a');
INSERT INTO hallo (ID, NAME) VALUES (2, 'b');
INSERT INTO hallo (ID, NAME) VALUES (3, 'c');
COMMIT;
CREATE OR REPLACE PACKAGE hoi IS
TYPE hallo_lines IS TABLE OF hallo%ROWTYPE;
FUNCTION h RETURN hallo_lines pipelined;
END;
CREATE OR REPLACE PACKAGE BODY hoi IS
FUNCTION h RETURN hallo_lines pipelined IS
r_hallo hallo%ROWTYPE;
BEGIN
FOR i IN (SELECT ID, NAME FROM hallo)
LOOP
r_hallo := i;
-- r_hallo.ID := i.ID;
-- r_hallo.NAME := i.NAME;
PIPE ROW(r_hallo);
END LOOP;
END;
END;
select * from table(hoi.h);
