PLS-00103 Encountered the Symbol ";" When Executing DBMS Package (Doc ID 443992.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

Symptoms

When executing the following:

SQL> EXECUTE DBMS_REFRESH.ADD(
name => 'kidreport.kidreportg1',
list => 'CMS_ADDRESS');

Get this - BEGIN DBMS_REFRESH.ADD(; END;

*
ERROR at line 1:
ORA-06550: line 1, column 24:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
( ) - + case mod new not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table avg count current exists max min prior sql stddev sum
variance execute multiset the both leading trailing forall
merge year month DAY_ hour minute second timezone_hour
timezone_minute timezone_region timezone_abbr time timestamp
interval date
<a string literal with character set specification>

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms