function - Oracle 10G:ORA-06575:函数处于无效状态

Question

我创造了这样的功能

CREATE OR REPLACE FUNCTION tax 
(p_sal IN  NUMBER(4)) 
RETURN NUMBER 
AS
v_tax NUMBER(4);
BEGIN 
v_tax:= CASE        
WHEN p_sal> 4000 THEN
p_sal*0.33       
WHEN p_sal >2500 THEN 
p_sal*0.25      
WHEN p_sal >1500 THEN 
p_sal*0.20     
ELSE 0         
END; 
RETURN v_tax;
END;
/

当我在插入stmt中使用此税收功能时

INSERT INTO employees(eno, ename, job, join_date, sal, comm)
VALUES (7784,'allen','salesman',sysdate, 5000, tax(5000));

它显示错误

ERROR: ORA-O6575: package or function tax is in invalid state.

谁能建议我如何使此功能处于有效状态？
提前致谢。

Answer 1

使用以下命令检查错误：

Select * from user_errors where name='Your function name'