iT SHOULD BE:

CREATE OR REPLACE PACKAGE BODY tms_ref_week_type (resultset weeks_ref)
IS
PROCEDURE ref_get_tms_weeks(resultset weeks_ref)
AS
begin
OPEN weeks_ref for
SELECT u_week_id from ref_tms_week order by u_week_id;

end;
/

-----Original Message-----
From: McGowan Annamarie
[mailto:oracledba-ezmlmshield-x76852803.[Email address protected]
Sent: Friday, October 28, 2005 3:03 PM
To: LazyDBA Discussion
Subject: Problem with Package


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




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page