ALTER keyword

Does anybody know the COMPLETE syntax for the ALTER statement for Object Types in PL/SQL?

Problem Specification:

CREATE OR REPLACE TYPE campus_club AS OBJECT (  Cid INTEGER
);

I want to add extra attibutes, so I have done this. ALTER TYPE campus_club (
 Name VARCHAR(20),
 Location VARCHAR(20),
 Phone INTEGER,
 Advisor ref person, -- Pid RELATION Advised by  Members club_members, -- RELATION Member of  MEMBER FUNCTION ivalidation RETURN BOOLEAN  --MEMBER FUNCTION get_value(return_value OUT Advisor)
);

SQL Plus gives me an error:
ALTER OR REPLACE TYPE campus_club AS OBJECT(

      *
ERROR at line 1:
ORA-00940: invalid ALTER command

SQL> Thanks
unknown command "Thanks" - rest of line ignored. SQL> Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 23 1999 - 12:55:27 CDT