Missing IN or OUT parameter at index: 1(Resolved)

I have provided the resolution for ‘Missing IN or OUT parameter at index: 1’ in this post. Useful for all SQL developers.