Re: ALTER keyword

A copy of this was sent to saks_at_saknar.com (if that email address didn't require changing) On Wed, 23 Jun 1999 17:55:24 GMT, you wrote:

>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.

sorry, you do not alter types -- you create or replace them. there is currently no schema evolution support with the types.

>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.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jun 23 1999 - 14:11:18 CDT