When I attempt to call the SQL Call Stored Procedure (SQLResult) service during debugging, I encounter above error. However, this error does not appear when running the service outside of debugging mode.

Could you please explain why this happens and provide a solution?

Normally when it only works in Debug or Runtime it's linked to your default values.

Can you post a bit more info about your query and your data that you are sending?