Getting Errors When Compiling The Invalid Objects In DLP Schema (Doc ID 1573271.1)

Last updated on OCTOBER 22, 2013

Applies to:

Oracle Argus Safety - Version 7.0.1 and later
Information in this document applies to any platform.

Symptoms

I started on the DLP schema and was able to successfully drop and recreate the db links to the correct schema.

how ever, within DLP I am unable to compile the following packages without warning:
SQL> select owner, object_name, object_type from dba_objects where status='INVALID' order by owner;

OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------ -------------------
DLP_USER ESM_IMP_UTL PACKAGE BODY
DLP_USER PKG_DLP_ETL PACKAGE BODY
DLP_USER ESM_UTL PACKAGE BODY
DLP_USER ESM_PKG PACKAGE BODY

I ran exec utl_recomp.recomp_serial;
and ran a compile on the package bodies via SQL developer. neither of those things seem to resolve the issue.

I also ran the E:\oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlrp.sql - same deal - still has errors in package body:

errors for ESM_PKG
Package Body DLP_USER.ESM_PKG@DEV-argsdlp
Error(2997,21): PL/SQL: SQL Statement ignored
Error(2998,26): PL/SQL: ORA-00980: synonym translation is no longer valid
Error(3003,6): PL/SQL: SQL Statement ignored
Error(3004,23): PL/SQL: ORA-00980: synonym translation is no longer valid
Error(3010,21): PL/SQL: SQL Statement ignored
Error(3010,33): PL/SQL: ORA-00980: synonym translation is no longer valid
Error(3015,17): PL/SQL: SQL Statement ignored
Error(3015,29): PL/SQL: ORA-00980: synonym translation is no longer valid
Error(3019,17): PL/SQL: SQL Statement ignored
Error(3019,29): PL/SQL: ORA-00980: synonym translation is no longer valid
Error(4857,3): PL/SQL: SQL Statement ignored
Error(4861,13): PL/SQL: ORA-00980: synonym translation is no longer valid

for example. Ideas?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms