Try displaying the ParamSessionClientID and making sure that the value is set correctly. There might not be any results returned since the session variable is not set correctly. Also, you can replace the session variable with a hardcoded value to test it directly in the database. Give that a try.