select * from yourstoredproc

Also may sure in your stored proc you are doing a for select with a
suspend