Re: Invalid status to Valid

Posted by ErmanArslansOracleBlog on Jul 10, 2020; 7:19am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Invalid-status-to-Valid-tp8492p8496.html

that is clear..
If you drop the sequence your dependent object will be invalid.
So far so good..
After you create that sequence again and then run your object/function, it'll successfully recompile itself automatically.

that is it.. You can test it yourself too.