ORA-00980 / ORA-06512 Errors And PL/SQL ERROR 201 When Compiling Forms
(Doc ID 2930498.1)
Last updated on AUGUST 10, 2023
Applies to:
Oracle Forms - Version 12.2.1.4.0 and laterOracle Forms for OCI - 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 |