Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: AA:Why the Object can not created in Oracle SQL*PLUS 8.0.4.00 ?

Re: AA:Why the Object can not created in Oracle SQL*PLUS 8.0.4.00 ?

From: Gary Waldrom <garyw_at_amonra-insight.com>
Date: Wed, 24 Nov 1999 19:03:48 -0000
Message-ID: <E47927FC0A9CD3119D090000216DAFF5B6F2@THOTH>


You haven't install the objects option when you installed the software

Gary Waldrom

Amonra Insight Ltd.
Makers of Q-file IT Quick Reference Guides http://www.q-file.com   

-----Original Message-----
From: centtel.com [mailto:gcao_at_centtel.com] Posted At: 24 November 1999 18:51
Posted To: server
Conversation: Why the Object can not created in Oracle SQL*PLUS 8.0.4.00?
Subject: AA:Why the Object can not created in Oracle SQL*PLUS 8.0.4.00?

Hi,
  I want to create object in Oracle SQL*PLUS 8.0.4.00. and I have a CREATE TYPE system privilege.   I write the following statement:
    create type ADDRESS_TY as object
    (street VARCHAR2(50),

     city    VARCHAR2(25),
     state   CHAR2(2),
     zip     NUMBER);

   But I get the message "feature not enabled:objects",Why?

   Thanks

           Mark Received on Wed Nov 24 1999 - 13:03:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US