Help with a table function
I am bad at PL/SQL and could not figure out why. Could you please help?
CREATE OR REPLACE PACKAGE MY_LIB AS
TYPE EMP_REC IS RECORD
(
emp_id number(4),
emp_name VARCHAR2(10)
)
;
TYPE EMP_TBL IS TABLE OF EMP_REC;
FUNCTION EMP_FN RETURN EMP_TBL;
END MY_LIB;
/
Package created.
CREATE OR REPLACE PACKAGE BODY MY_LIB AS
FUNCTION EMP_FN RETURN EMP_TBL
AS
MY_EMP_TBL EMP_TBL;
BEGIN
SELECT EMPNO, ENAME BULK COLLECT INTO MY_EMP_TBL
FROM EMP
;
RETURN MY_EMP_TBL;
END EMP_FN;
END MY_LIB;
/
Package body created.
SELECT * FROM TABLE(MY_LIB.EMP_FN);