Hi Mark,

I see in your example that you use the '?' to pass your date variable. As in the example I gave that was working for me. What I'd like is to be able to pass the date the same way I passed the numeric. If it's not possible to do it. I'm ok with the '?ldWorkWeek' way. This is primarily a quriosity issue from a newbee.

Here is the package body part:

 Procedure ReturnSpecHrsOffice(
   pnPersNo IN PROJ_HRS.PERS_NO%Type,
   pdWorkWeek IN PROJ_HRS.WRK_WEEK%Type,
   pCursor OUT RetCursor)

 IS
 Begin
  open pCursor for
	SELECT PROJ_HRS.*,
	  0 AS new_line,
	  0 AS match_found,
	  0 AS line_chng
	FROM PROJ_HRS,
	  PROJ_SPEC
	WHERE PROJ_HRS.proj_cat_no = 3
	  AND PROJ_HRS.pers_no = pnPersNo
	  AND PROJ_HRS.wrk_week = pdWorkWeek
	  AND PROJ_HRS.wrk_hrs <> 0
	  AND PROJ_HRS.proj_no = PROJ_SPEC.proj_no (+)
	ORDER BY PROJ_HRS.accepted,
	  PROJ_HRS.refused;
 End;
END;

Mike