-
The following function is valid in 8i, but when used in 9i, it gives me the following error:
"TYPES.REF_CURSOR' must be declared"
CREATE OR REPLACE FUNCTION getUsers
RETURN TYPES.ref_cursor
AS
crsUsers TYPES.ref_cursor;
BEGIN
OPEN crsUsers FOR
SELECT NVL(ID, -1) AS ID,
NVL((FirstName || ' ' || LastName), 'Null Value') AS Descript,
NVL(Status, -1) AS Status
FROM Users
ORDER BY Descript;
RETURN crsUsers;
END;
/
Could it possibly be a configuration (or lack thereof) problem?
Thanks very much in advance for any help!
Shannon
-
I can tell you that it doesnt work in 8i neither
ref_cursor is not a standard type, you have to create it previously
Code:
create or replace package types
is
type ref_cursor is ref cursor;
end;
/
[Edited by pando on 07-25-2002 at 06:06 PM]
-
Pando,
My mistake. It worked, and thanks very much!
Shannon
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
|