cursor in function

From: Dan Hess <dah23_at_cornell.edu>
Date: Fri, 11 Jun 1999 11:47:01 -0400
Message-ID: <37612F74.4FFF54C3@cornell.edu>

with the following code,

create or replace function opendir(did in integer, uid in integer) return
types.cursortype
as dir_cursor types.cursortype;

begin

open dir_cursor for select filename, filetype, filesize, description, downloads from files, ug

where

 files.parent = did
 and ( files.groupid in
 (select ug.groupid
 from ug
 where ug.userid = uid and gstatus = 0)  or files.permission > 1 )
order by directory, filename;

return dir_cursor;

end;
/

---

I get the error

0/0      PL/SQL: Compilation unit analysis terminated
1/57     PLS-00201: identifier 'TYPES.CURSORTYPE' must be declared

Where do i need to declare this?

Thanks a lot, Dan Received on Fri Jun 11 1999 - 10:47:01 CDT