Invalid status to Valid

Posted by satish on Jul 09, 2020; 12:20pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Invalid-status-to-Valid-tp8492.html

Dear Erman,

We have created one function yesterday which went to invalid state after creation.But today,when we check that it is showing valid status.Below is the function.Without any explicit compilation from dba,what might be the reason to change invalid state to valid.


create or replace FUNCTION xxabr.xxabr_value_autopopulate
     RETURN VARCHAR2 AS
l_value VARCHAR2(100);

BEGIN
    SELECT
        'WO_'||xxabr.xxabr_WO_SEQ.nextval INTO l_value
        FROM
        dual;
        RETURN l_value;
END;

Thank You