If you do alter table in Oracle database, your stored procedures or views' state may become invalid as bellows:
You need to rebuild all invalid stored procedures one by one
If I have multiple invalid stored procedures, it will be very annoying.
Does Oracle provide any convenient way to rebuild all invalid stored procedures?
You can use exec dbms_utility.compile_schema(SCHEMA NAME) to fulfill this requirement. Assume my schema name is AP_PSR, then the command is as follows:
See...all invalid stored procedures had become invalid