Would help to see the stored procedure code and how you are actually calling it. Just based on your initial post, hard to tell you what is happening.