I am trying to get into your problem but what i don;t understand is you are expecting to provide schoolname as input variable for the sp ....