>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.