Re: Oracle8: ALTER TYPE does not work ?

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Mon, 7 Dec 98 15:21:03 +0200
Message-ID: <AD_OzQsK42@protasov.kiev.ua>

Hi,

Why do you not use CREATE or REPLACE instead of ALTER?

SVRMGR> CREATE OR REPLACE TYPE GeoCoord AS OBJECT
     2> (Longitude NUMBER
     3> ,Latitude  NUMBER
     4> );

Statement processed.

SVRMGR> /
SVRMGR> CREATE OR REPLACE TYPE GeoCoord AS OBJECT
     2> (bla NUMBER
     3> );

Statement processed.
SVRMGR> / Andrew Protasov

> Hi,
>
> I am setting up an oracle training for our students, including
> a small Oracle8 part.
>
> Types can be generated, but the ALTER TYPE Statement (with the syntax
> given in the server manual) produces an error (Oracle 8.0.3.0.0):
>
> CREATE OR REPLACE TYPE GeoCoord AS OBJECT
> (Longitude NUMBER,
> Latitude NUMBER);
> /
> 2 3 4
> Typ wurde erstellt.
> [engl: Type has been generated]
>
> SQL> ALTER TYPE GeoCoord REPLACE AS OBJECT
> (bla number);
> 2 ALTER TYPE GeoCoord REPLACE AS OBJECT
> *
> FEHLER in Zeile 1:
> ORA-22319: Typattributinformationen in ALTER TYPE geaendert
> [engl: Type Attribute Information changed with ALTER TYPE]
>
> Any hints (the same occurs when member methods are defined in the
> ALTER TYPE statement) ?
>
> Wolfgang
>
> -- -----------------------------------------------------------------
> Dipl.Inform.Wolfgang May E-mail: may_at_informatik.uni-freiburg.de
> Universitaet Freiburg http://www.informatik.uni-freiburg.de/~may/
> Institut fuer Informatik D-79110 Freiburg / Germany
> Lehrstuhl fuer Datenbanken und Informationssysteme
> Tel ++49 761 203-8131 Fax ++49 761 203-8122
>
>
Received on Mon Dec 07 1998 - 07:21:03 CST