How To Extract Just One Attribute From A Stored Procedure?

The my_stored_procedure returns a result set of values for attribute "id" and "name".

My attempt to extract just the id values from my_stored_procedure has a syntax error:



Code Snippetselect id from (execute my_stored_procedure);




I want to use it in a query



Code Snippet
if 32 in (Select id from (execute my_stored_procedure));
select 1 as valid;


What€™s the correct way to do this?


Thank you.