Oracle 10G: ORA-06575: function in invalid state

function oracle10g
Bhavana picture Bhavana · Mar 6, 2011 · Viewed 43.3k times · Source

I created a funcion like this 

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;
/

when i used this tax function in insert stmt like

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

it shows the error like

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

can anyone suggest me how to make this function is in valid state? thanks in advance.

Answer

klkkhkjkj picture klkkhkjkj · Jun 1, 2014

Check errors with this command:

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

Related questions

Function return sys_refcursor call from sql with specific columns

This may find little silly, but I would like to know whether this is possible. I have a function which return sys_refcursor CREATE OR REPLACE FUNCTION get_employee_details(p_emp_no IN EMP.EMPNO%TYPE) RETURN SYS_REFCURSOR …

Read More
Cannot call oracle stored procedure and function

Might be too simple question to ask, but I do need help. I am creating a stored procedure in Oracle 10g, but I cannot call it. I am using SQL Developer to manage the database. CREATE OR REPLACE FUNCTION check_…

Read More
Oracle Function: Replicate wm_concat

I currently am working on a project within Crystal Reports that refuses to use the undocumented function WM_CONCAT, which is allowable within Oracle 10g. Here is the WM_CONCAT header information WM_CONCAT(p1 IN VARCHAR2) RETURN VARCHAR2 To …

Read More