RE: Error-00103 While Creating Type

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Wed, 11 Apr 2001 01:48:08 -0700
Message-ID: <F001.002E6CE6.20010411005522@fatcity.com>

Dear Vadim Gorbounov

Thank you, very much. It works. I was missing 'AS OBJECT'

Thanx once again.

Regards,

Aleem

-----Original Message-----
Sent: Tuesday, April 10, 2001 8:13 PM

To:     Multiple recipients of list ORACLE-L
Subject:        RE: Error-00103 While Creating Type

Hi, Aleem,
Try this:
CREATE OR REPLACE TYPE
abc as object (

         Emp_Name      VARCHAR2(30),
         Emp_Desgn     VARCHAR2(30),
         Emp_Addrs      VARCHAR2(50) );

Hope this helps
Vadim Gorbounov
Oracle DBA

-----Original Message-----
Sent: Tuesday, April 10, 2001 3:20 AM
To: Multiple recipients of list ORACLE-L

Thanks, I used Abc, Test_1 etc. but the error remains.

Any other suggestion!

TIA Aleem

-----Original Message-----
Sent: Monday, April 09, 2001 9:46 PM

To:     Multiple recipients of list ORACLE-L
Subject:        RE: Error-00103 While Creating Type

Test is a reserved word. Use TEST_1 and everything will be all right.

-----Original Message-----
Sent: Saturday, April 07, 2001 3:00 AM
To: Multiple recipients of list ORACLE-L

Hi!

When I execute the following code on Oracle 8i release 3 (8.1.7)

CREATE OR REPLACE TYPE
Test (

         Emp_Name      VARCHAR2(30),
         Emp_Desgn     VARCHAR2(30),
         Emp_Addrs      VARCHAR2(50) );

It gives error

"Type created with compilation errors".

The All_Errors view indicates Error-00103 at line 2 position 6

"Encountered symbol '(' when expecting ; is authid as compress compiled wrapped'

TIA Regards,

Aleem

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Abdul Aleem
INET: abchaudhary-ho_at_beaconhouse.edu.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gogala, Mladen
INET: MGogala_at_oxhp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------