I had successfully compiled a procedure. Later, I did some changes to the table, which is being populated by that table. I dropped a few columns and added a few columns. To prove I am a human, I dint update that procedure. End, I hit with this error.
PLS-00905: Object UPDATE_TABLE is invalid.
So I had made the necessary changes to the procedure also and recompiled it. Now, it is working fine.