I have a view X and this view selects column 1,2,3 from a table Y.
I have some procedures and packages in my schema which references this view i.e inside those procedures and packages i use the view X.
Now my client wants to alter the structure of the view so that it also takes column 4 from table Y.I know that the the dependent objects i.e procedures and packages referring view X will get invalidated when i change the view structure.
dO i need to do a manual recompile or will Oracle automatically recompile the procedures and packages,the next time when someone invokes it.
My Oracle version is 22.214.171.124
Please reply urgently