Stored procedure invalidates when table is changed
I have a stored procedure that reference a database table. Whenever I add or remove a column from the table, my stored procedure is automatically made invalid. I understand why it would want to do that but is there a way to turn that off cu'z the columns that I create and remove are not referenced in the stored procedure and never will be. Can anyone tell me how to turn that off in Oracle? Thanks...