amortillaro
Programmer
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
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