The following errors are observed in desvr log when compare failed:
desvr 2018-06-20 13:01:10.216266 19202946 258 [1] Oracle Error 4063: ORA-04063: package body "OWNER.SP_DEQ_PKG" has errors
desvr 2018-06-20 13:01:10.216266 19202946 258 [1]
desvr 2018-06-20 13:01:10.235355 19202946 258 [1] Error 4063 calling OCIStmtExecute (de_select_prepare_to_fetch,L1418)
desvr 2018-06-20 13:01:10.236408 19202946 258 [1] Error 1 calling de_select_prepare_to_fetch in de_batch_setup
desvr 2018-06-20 13:01:10.241470 19202946 258 [1]
Furthermore, when attempting to manually recompile the package in the database, the folloiwng errors are observed (shown here is the partial output):
SQL> alter package SP_DEQ_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY SP_DEQ_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
12/6 PL/SQL: SQL Statement ignored
12/13 PL/SQL: ORA-00904: "DBMS_LOB"."SUBSTR": invalid identifier
60/21 PL/SQL: Item ignored
60/31 PLS-00201: identifier 'DBMS_LOB' must be declared
74/7 PL/SQL: Statement ignored
74/14 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
79/7 PL/SQL: Statement ignored
79/20 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
LINE/COL ERROR
-------- -----------------------------------------------------------------
95/7 PL/SQL: Statement ignored
95/36 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
117/7 PL/SQL: SQL Statement ignored
117/14 PL/SQL: ORA-00904: "DBMS_LOB"."SUBSTR": invalid identifier
133/21 PL/SQL: Item ignored
133/31 PLS-00201: identifier 'DBMS_LOB' must be declared
146/7 PL/SQL: Statement ignored
....
