Row Level RLS function Hangs up.

I create this function in an Oracle 9i database. Then I attach it to the EMP table (SELECT, UPDATE, etc.). When I issue "select * from emp" it hangs up forever.

	CREATE OR REPLACE FUNCTION rls_sal (
		p_schema_name IN VARCHAR2,
		p_object_name IN VARCHAR2
	)
		RETURN VARCHAR2
	IS
		l_return_val VARCHAR2(2000);
		l_avg_sal NUMBER;
	BEGIN
		select avg(sal) into l_avg_sal from emp;
		l_return_val :=
			'SAL > ' || l_avg_sal;
		RETURN l_return_val;
	END rls_sal;
	/

I appreciate your help! Received on Thu May 17 2007 - 09:04:34 CDT