-
Hi got following error while compiling the package body ... any suggestion ????
5/2 PLS-00306: wrong number or types of arguments in call to 'SERVTYP'
5/2 PL/SQL: SQL Statement ignored
Create or Replace Package TaskingInstr AS
TYPE ServTyp IS REF CURSOR RETURN EMP%ROWTYPE;
PROCEDURE FindTaskDetail(ServId IN varchar2, DevId IN Varchar2, ServRec IN OUT ServTyp);
End TaskingInstr;
/
Create or Replace Package Body TaskingInstr AS
PROCEDURE FindTaskDetail(ServId IN varchar2, DevId IN Varchar2, ServRec IN OUT ServTyp) IS
Begin
OPEN ServTyp
FOR
SELECT * FROM EMP
WHERE Device_Id = DevId
AND Service_id <> ServId;
End FindTaskDetail;
End TaskingInstr;