Problem in using Stored Function in SQL statement

[Quoted] Hi, if anyone could help!

[Quoted] I have this stored function on the server : IS_STATUS_ACTIVE() This function should return BOOLEAN result.

What I want to do is to perform a SQL which selects only those record that have active status. I have the following SQL statement in another stored procedure :

	SELECT emp_num 
	FROM 	employee
	WHERE	IS_STATUS_ACTIVE(emp_status);

PL/SQL just won't let me save the procedure saying that

PLS-00425: in SQL, function argument and return types must be SQL type.

Does anyone have any idea ?

Thanks Received on Tue Apr 15 1997 - 00:00:00 CEST