Re: I can't create OBJECT TYPE in sql*plus!!

You don't have the Objects option installed. Do you have an 8.0.5 Enterprise Edition simply install the feature. If you have a Standard Edition, you cannot use objects...

HTH. Finn

victor <lch_2_at_hotmail.com> wrote in message news:38C0F421.F0668ED8_at_hotmail.com...
> Hi everyone,
> I got a problem in creating object in sql*plus.
> Here is the CREATE TYPE statement that i type:
>
> CREATE TYPE address_type AS OBJECT(
> street varchar2(25),
> city varchar2(25),
> post_code varchar2(10),
> country varchar2(20))
> /
>
> However, an error message is displayed:
>
> 'feature not enable: Objects'
>
> I dont' know what's wrong with it. I am sure the code is correct, it is
> because it is so simple and I can create the object in my school oracle
> account. But just can't create it in my notebook.
>
> The copy of oracle I am using in my notebook is downloaded from the
> oracle webpage. Its version is Oracle8.05.
> Would anybody teach me how to deal with this problem?
>
> Thank you very much!
>
> Victor Lung
>
Received on Sat Mar 04 2000 - 00:00:00 CST