RMS 16.0.2 to 16.0.3 patch upgrade failing
ORA-04063: package body "RMSDEV.LOGGER" has errors
ORA-06508: PL/SQL: could not find program unit being called: "RMSDEV.LOGGER"
Asked customer to open the package LOGGER from SQL Developer and the below error were noted.
PL/SQL: Statement ignored ERROR
PLS-00222: no function with name 'V' exists in this scope ERROR
PL/SQL: Statement ignored ERROR
PLS-00222: no function with name 'V' exists in this scope ERROR
PL/SQL: SQL Statement ignored ERROR
PL/SQL: ORA-00904: "V": invalid identifier ERROR
The error was pointing to call to the function "V" in snapshot_apex_items
$if $$no_op $then
null;
$else
ORA-06508: PL/SQL: could not find program unit being called: "RMSDEV.LOGGER"
Asked customer to open the package LOGGER from SQL Developer and the below error were noted.
PL/SQL: Statement ignored ERROR
PLS-00222: no function with name 'V' exists in this scope ERROR
PL/SQL: Statement ignored ERROR
PLS-00222: no function with name 'V' exists in this scope ERROR
PL/SQL: SQL Statement ignored ERROR
PL/SQL: ORA-00904: "V": invalid identifier ERROR
The error was pointing to call to the function "V" in snapshot_apex_items
$if $$no_op $then
null;
$else
0