>does this mean I have to store my results into a temp table because I can only close the cursor in a stored procedure?

Why not close the cursor in the stored procedure after returning the results? That's what we do here and have not had a problem. Again, I'm not familiar with Oracle in particular, but it can't be that much different from SQL Server.