My Oracle Support Banner

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 JANUARY 30, 2022

Applies to:

PL/SQL - Version and later
Information in this document applies to any platform.


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 [2604]

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:



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.