-
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|