I keep getting an error when trying to create a package using a
REF_CURSOR, the error is: (S41) Expecting: . AS IS WRAPPED

I'm new to Oracle so any help is appreciated

Here is the info:

CREATE OR REPLACE PACKAGE tms_ref_week_type is
TYPE weeks_ref IS REF CURSOR;
PROCEDURE ref_get_tms_weeks(resultset weeks_ref);

end;
/







CREATE OR REPLACE PACKAGE BODY tms_ref_week_type (resultset weeks_ref)
IS

begin
OPEN weeks_ref for
SELECT u_week_id from ref_tms_week order by u_week_id;

end;
/



Oracle LazyDBA home page