My Oracle Support Banner

PLS-00103 When Trying to Create Type with Force OID option (Doc ID 1572654.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When trying to create TYPE with force OID option, it fails with below error

 

Error Message:

=========

PLS-00103: Encountered the symbol "OID" when expecting one of the following: is authid as under.

 

Oracle documentation confirm that create or replace TYPE with force ODI option is allowed, see below

CREATE [OR REPLACE] TYPE [ schema. ] type_name [ FORCE ]
   [ OID 'object_identifier' ]

   [ object_type
   | | { IS | AS } { varray_type_def | nested_table_type_def }
   ];

 

Issue can re-produced using below test :

QL> CREATE OR REPLACE TYPE type_test OID 'D8503384A93C103BE040C10A86041D7B'
AS TABLE OF NUMBER(38);
  2  /

Type created.

SQL> CREATE OR REPLACE TYPE type_test OID 'D8503384A93C103BE040C10A86041D7B'
AS TABLE OF NUMBER(38);
  2  /

Type created.

SQL> /

Type created.

SQL> CREATE OR REPLACE TYPE type_test force OID
'D8503384A93C103BE040C10A86041D7B' AS TABLE OF NUMBER(38);
  2  /

Warning: Type created with compilation errors.

SQL> show errors
Errors for TYPE DTYPE_TEST:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/23     PLS-00103: Encountered the symbol "OID" when expecting one of the
         following:
         is authid as under

 



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.