Using Fully Qualified Database Link Name With a Hyphen in the Domain Name From PL/SQL Fails With ORA-02083, But Not From Regular SQL
(Doc ID 331169.1)
Last updated on SEPTEMBER 28, 2020
Applies to:PL/SQL - Version 220.127.116.11 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Aug-2017***
This problem is characterized by an ORA-2083 'database name has illegal character '-'' error when using a fully qualified database link that has a hyphen in the domain name.
When remote database i.e standby database is 8.0.6
ORA-02083: database name has illegal character '
PLS-00905 object is invalid (for package compilation)
When remote database i.e standby database is 8.1.7 or later
ORA-02083: database name has illegal character '`'
ORA-06553: PLS-707: unsupported construct or internal error 
This error only occurs when the database link is used in PL/SQL.
When the same database link is used in SQL, the call is successful.
This could especially happen when the remote database is a READ ONLY STANDBY Database.
Even if the CREATE DATABASE LINK succeeds:
" using 'ora92';
Database link created.
The PL/SQL execution fails when referencing the DATABASE LINK Unquoted:
The PL/SQL execution fails when referencing the DATABASE LINK quoted:
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