My Oracle Support Banner

Running DMKR_ADMIN.SQL Fails In SQLDeveloper (Doc ID 2822349.1)

Last updated on NOVEMBER 19, 2021

Applies to:

Oracle Documaker - Version 12.6.4 and later
Information in this document applies to any platform.


On : 12.6.4 version, Enterprise Edition

When executing the DMKR_ADMIN.SQL in SQLDeveloper, the following error is returned three times (see below). After some analysis, it was discovered that the SQL Scripts contain the "." character on three lines (2764, 2862, and 2892). These erroneous characters will cause the PL/SQL to fail compilation and the respective components will not be available in the database. It is unknown if there are any repercussions to these failures. The SQL script will complete successfully if executed in SQL*PLUS however a customer is free to run the SQL in any tool they wish. If the "." lines are removed, the script will complete normally in SQL*PLUS and SQLDeveloper. Recommended fix is to remove the lines.
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "." when expecting one of the following:
  ( begin case declare end exception exit for goto if loop mod
  null pragma raise return select update while with
<< continue close current delete fetch lock
  insert open rollback savepoint set sql execute commit forall
  merge pipe purge json_exists json_value json_query
  json_object json_array
The symbol "." was ignored.
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
-------- -----------------------------------------------------------------
96/1 PLS-00103: Encountered the symbol "." The symbol "." was ignored.
Commit complete.


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

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