[Terry Note] ora-00904 invalid identifier-Synonym

Today, I encountered a problem, which is easy to say, but it bothered me for half a day.

After upgrading the database, a function can not run, in the background to observe its SQL, found that SQL contains a package can not be executed, error ora-00904 invalid identifier

Wmsys. dbms_lob.xxx is the package.

Select * from dba_source; you can find that dbms_lob belongs to sys.

Change wmsys. dbms_lob.xxx in SQL to sys. dbms_lob.xxx or dbms_lob.xxx.

However, developers do not want to modify the source code. After thinking about it, find a solution:

Log on to the wmsys user and execute create synonym dbms_lob for sys. dbms_lob;

Create a synonym.