Create a Stored procedure report ORA-00904

The newly developed colleague came to me, after adding a field to a table on the intranet database, and then creating the stored procedure, the error indicates that the new field is invalid.

Warning:procedure created with compilation errors.

Sql> Show Error
Errors for PROCEDURE cb_date_modify:

Line/col ERROR
-------- -----------------------------------------------------------------
37/20 Pl/sql:sql Statement ignored
37/27 pl/sql:ora-00904: "A3". " OLD_ID ": Invalid identifier

There have been similar problems before, it is estimated that the shared pool is related, because it is the Intranet test library, so directly flush the shared pool

Sql> alter system flush Shared_pool;

System altered.

sql> Create or replace procedure cb_date_modify is

。。。。

。。。。

/

Procedure created.