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
OPEN crsUsers FOR
SELECT NVL(ID, -1) AS ID,
NVL((FirstName || ' ' || LastName), 'Null Value') AS Descript,
NVL(Status, -1) AS Status
ORDER BY Descript;
Could it possibly be a configuration (or lack thereof) problem?
Thanks very much in advance for any help!
I can tell you that it doesnt work in 8i neither
ref_cursor is not a standard type, you have to create it previously
[Edited by pando on 07-25-2002 at 06:06 PM]
create or replace package types
type ref_cursor is ref cursor;
My mistake. It worked, and thanks very much!
Click Here to Expand Forum to Full Width