PL/SQL (MOSC)

MOSC Banner

Help with a table function

edited Jul 7, 2014 11:17AM in PL/SQL (MOSC) 6 commentsAnswered ✓

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center