My Oracle Support Banner

ORA-00980 / ORA-06512 Errors And PL/SQL ERROR 201 When Compiling Forms (Doc ID 2930498.1)

Last updated on FEBRUARY 23, 2023

Applies to:

Oracle Forms - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Unable to compile Forms after database migration to a different server.

Getting the following errors:

ORA-00980: synonym translation is no longer valid
ORA-06512: at "ORA_DE", line 1233

Compiling procedure <procedure name>...
Compilation error on procedure<procedure name>:
PL/SQL ERROR 201 at line 75, column 11
identifier 'DBMS_LOB' must be declared
PL/SQL ERROR 0 at line 75, column 4
SQL Statement ignored
PL/SQL ERROR 201 at line 92, column 11
identifier 'DBMS_LOB' must be declared
PL/SQL ERROR 0 at line 92, column 4
SQL Statement ignored
...
...
Compiling procedure <procedure name>...
Compilation error on procedure <procedure name>:
PL/SQL ERROR 201 at line 68, column 11
identifier 'DBMS_LOB' must be declared
PL/SQL ERROR 0 at line 68, column 4
SQL Statement ignored
PL/SQL ERROR 201 at line 86, column 11
identifier 'DBMS_LOB' must be declared
PL/SQL ERROR 0 at line 86, column 4
SQL Statement ignored
PL/SQL ERROR 201 at line 103, column 11
identifier 'DBMS_LOB' must be declared
PL/SQL ERROR 0 at line 103, column 4
SQL Statement ignored

Changes

 Migrated database to a different server.

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
Changes
Cause
Solution


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