Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to declare a cursor ...?

Status
Not open for further replies.

amortillaro

Programmer
Dec 1, 2003
25
US
Hi all:
I'm creatinga package, with a procedure. Inside that procedura I'm declaring the following cursor and a variable of it's rowType:
CURSOR crEmOneDay(pcrEmKey varchar2, paramDate date)
IS
Select EmKey, AttDate1, ClockIn, ClockOut
From Att_Employees
Where ((EmKey = pcrEmKey)
And (AttDate1 = To_Date(paramDate)) )
Order By EmKey ASC, AttDate1 ASC, ClockIn ASC;
rowOneEntry crEmOneDay%RowType;

I need then to call a function that receive a rowOneEntry type parameter.
My question: where should I declare the parameter type "crEmOneDay%RowType" so that in the package declaration I could say:

Function punchBySched(rowEntry in crEmOneDay%RowType,
pEmTm in varchar2)
Return crEmOneDay%RowType;

Thanks in advance... Aishel
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top