Incorrect syntax near 'Connor'. Unclosed quotation mark after the character string ''.
exec Autos_GetZipCodeByStateAbbAndCity 'tx','Port O'Connor'