Stored Procedure throwing error 2646(spool space)

Database

Stored Procedure throwing error 2646(spool space)

I have a procedure which is throwing me error for spool space.

Error 2646: No more spool space for user.

But when i execute the contents of the procedure outside in sql assistant,it runs fine and i get the output within a minute.

Can someone help me with this?