Hi Experts,
We have created one function yesterday.Developer came to us today and said the function is in invalid state.We missed to check the status after function creation.
But today,After some time when the developer reported,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