Re: Member Funtion Error

Thanks Pete.

I now have another slight problem. I have used the following code to create a new method:
MAP MEMBER FUNCTION getLname RETURN varchar2, PRAGMA RESTRICT_REFERENCES (getLname, WNDS, WNPS, RNDS, RNPS)

(I have included this in my ALTER TYPE code and it executes without errors)

but when I run the following code:
CREATE OR REPLACE TYPE BODY student_type IS

    MEMBER FUNCTION getName RETURN VARCHAR2 IS BEGIN
 RETURN (FirstName || ' ' || LastName);
END; MAP MEMBER FUNCTION getLname RETURN VARCHAR2 IS BEGIN
 RETURN (LastName);
END;
END;
/

I get the following error:
CREATE OR REPLACE TYPE BODY student_type IS *
ERROR at line 1:
ORA-21700: object does not exist or is marked for delete

Any help would be much appreciated.
James Received on Sun Nov 16 2003 - 14:13:01 CST