Using procedure as part of 'where' clause

[L S W <wolf@TAVERN.COM>]

I am having problems doing something I'm sure is simple. I wrote a stored
procedure that returns a single column result set. It takes a single integer
input paramater.

call list_reports(1111)

returns about 70 rows.

I want to do the following:

SELECT employees WHERE emp_id in(list_reports(1111));

But the error message says "invalid number of paramaters passed to
function". What is the proper syntax? Thanks.

Larry Wolf