Re: user defined datatypes.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 24 Mar 2001 15:40:09 +0100
Message-ID: <tbpca8nqnr8o1a@beta-news.demon.nl>

"Salnik Andrej" <d95014_at_htlwrn.ac.at> wrote in message news:3ABCAF06.BB2571B6_at_htlwrn.ac.at...
> hi
>
> i have a problem with user defined datatypes.
> i just tried tu create a simple datatype but i get an error
> ORA-00439: function Objects is not activated
>
> or something like that.
> i have an oracle server 8.0.4.0.0
>
> my datatype
>
> create type o_Telefon as Object(
> Land varchar2(20),
> Vorwahl varchar2(10),
> Anschluss varchar2(10)
> )
> /
>
> can someone help me?
>
> thanks
>

The objects option is available in the Enterprise Edition only. You are running the Standard Edition.
(Check v$version and v$option, and you will see this confirmed) Also, 8.0.4 has been desupported more than a year ago. You should upgrade to 8.1.6 or 8.1.7 as 8.0 is on the way out.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Mar 24 2001 - 08:40:09 CST