存儲過程返回cursor

CREATE OR REPLACE FUNCTION FUNCTIONNAME  RETURN  SYS_REFCURSOR IS CURSORNAME SYS_REFCURSOR; BEGIN     OPEN CURSORNAME FOR     select *  from DUAL;     RETURN stock_cursor; END;