>naomi thanks for your corrections, but still does not return data here is two pictures of when I run with local parameters
Try using named parameters instead. If the local code worked, I see no reason for calling the same sp to not work. Unless the code of SP hasn't changed.
If it's not broken, fix it until it is.
My Blog