RE: Error-00103 While Creating Type

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Mon, 09 Apr 2001 09:00:27 -0700
Message-ID: <F001.002E543A.20010409084620@fatcity.com>

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
--------------------------------------------------------------------