DB version : 11g
I have a Package which i am trying to compile. The package won't compile because of around 25 tables and nearly 100 columns referenced in the package is which are missing in the schema.
These tables and columns are no longer needed. I need to remove the references to these table and columnsfrom the code.
Every time i get an error when i type SHOW ERRORS, i get something like below. After removing these columns and tables from the code, evertime i try to recompile the package i get a new set of
invalid identifier (missing columns) and
table or view does not exist errors. This is very tedious and time consuming.
How can i see all the errors at once ?
ORA51>show errors
Errors for PACKAGE BODY TGT_PROCESS_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2133/7 PL/SQL: SQL Statement ignored
2154/36 PL/SQL: ORA-00904: "SHP_LANE_ID": invalid identifier
2403/7 PL/SQL: SQL Statement ignored
2640/50 PL/SQL: ORA-00904: "SINGLE_FLAGS": invalid identifier
2711/7 PL/SQL: SQL Statement ignored
2833/39 PL/SQL: ORA-00904: "AL_QTY_UOM": invalid identifier
3158/7 PL/SQL: SQL Statement ignored
3284/44 PL/SQL: ORA-00904: "VOLUME_UOM_ID": invalid identifier
3391/7 PL/SQL: SQL Statement ignored
3397/17 PL/SQL: ORA-00942: table or view does not exist
3412/7 PL/SQL: SQL Statement ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
3425/17 PL/SQL: ORA-00942: table or view does not exist
3435/7 PL/SQL: SQL Statement ignored
3435/19 PL/SQL: ORA-00942: table or view does not exist
3440/7 PL/SQL: SQL Statement ignored
3440/19 PL/SQL: ORA-00942: table or view does not exist
3598/7 PL/SQL: SQL Statement ignored
3598/19 PL/SQL: ORA-00942: table or view does not exist
3602/7 PL/SQL: SQL Statement ignored
3602/19 PL/SQL: ORA-00942: table or view does not exist