I created a function Get_emp_Id which returns emp_id in recordset . I want to use this function in SQL statement with where condition

SELECT * From EMP where emp_id in (Get_emp_Id);

But I got an error ORA-00932: inconsistent datatypes: expected - got CURSER

Can Anyone please help me to call above function in where clause of select statement ?