My Oracle Support Banner

ORA-20001, PLS-00103 Error Importing An Application In Apex (Doc ID 1453214.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Application Express (APEX) - Version 4.1.0 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

While importing an APEX Application getting:

ORA-20001: Execution of the statement was unsuccessful. ORA-06550: line 32, column 14: PLS-00103: Encountered the symbol "P_SOURCE_TYPE" when expecting one of the following:
. ( ) , * @ % & = - + < / > at in is mod remainder not rem => <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset The symbol "." was substituted for "P_SOURCE_TYPE" to continue.

declare h


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.