SQL Server Prozeduraufruf - Keine Werte mehr nach 256 aufrufen

ALTER PROCEDURE [proc_Geocode]
	@AdressID int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	Declare @Adresse nvarchar(255)
	Declare @ResponseText as Varchar(8000);
	Declare @serviceUrl as varchar(500)
	Declare @partial_match as varchar(20)
	Declare @Object as Int;
	Declare @GeocodeID int

	SELECT @GeocodeID = ID from TBL_Adressen_Geocodes where Adress_ID = @AdressID

	SELECT @Adresse = Adresse from avw_Adresse_Zusammen where Adress_ID = @AdressID

	Set @Adresse = REPLACE(@Adresse,' ','+')  
	Set @Adresse = REPLACE(@adresse,'.','')  
	Set @Adresse = REPLACE(@adresse,',','')  
	Set @Adresse = REPLACE(@adresse,'/','')  
	Set @Adresse = REPLACE(@adresse,'ß','ss')  
	Set @Adresse = REPLACE(@adresse,'ä','ae')  
	Set @Adresse = REPLACE(@adresse,'ö','oe')  
	Set @Adresse = REPLACE(@adresse,'ü','ue')  


	set @serviceUrl = 'https://maps.googleapis.com/maps/api/geocode/xml?address='+@Adresse  
	+'&language=de&key=$$KEY$$'  
	print @serviceUrl
	Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;  
	Exec sp_OAMethod @Object, 'open', NULL, 'get',  
					@serviceUrl, --Your Web Service Url (invoked)
					 'false'  
	Exec sp_OAMethod @Object, 'send'  
	Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT  
	

	Declare @Response as XML

	--Select @ResponseText as XMLList
	--set @ResponseText = REPLACE(@responsetext,'ß','ss')  
	--set @ResponseText = REPLACE(@responsetext,'ü','ue')  
	--set @ResponseText = REPLACE(@responsetext,'ä','ae')  
	--set @ResponseText = REPLACE(@responsetext,'ö','oe')  
	--set @ResponseText = REPLACE(@responsetext,'ú','u')  

	set @ResponseText = replace(@responsetext,'<?xml version="1.0" encoding="UTF-8"?>','<?xml version="1.0" encoding="ISO8859-1"?>')  
	
	begin try
		SET @Response = CAST(@ResponseText AS XML);
		-- Insert statements for procedure here
		set @partial_match = @Response.value('(/GeocodeResponse/result/partial_match)[1]', 'varchar(255)')  
		if @partial_match = 'true'  
		begin
			set @partial_match = ' / Partial Match'  
		end
		else
		begin
			set @partial_match = ''  
		end

		if @GeocodeID > 0
		begin
			Update TBL_Adressen_Geocodes set lat = @Response.value('(/GeocodeResponse/result/geometry/location/lat)[1]', 'numeric(18,9)'),lng =   
			@Response.value('(/GeocodeResponse/result/geometry/location/lng)[1]', 'numeric(18,9)'), formatted_address =  
			@Response.value('(/GeocodeResponse/result/formatted_address)[1]', 'nvarchar(255)'),street =  
			@Response.value('(/GeocodeResponse/result/address_component[type="route"]/long_name)[1]', 'nvarchar(50)'), street_number =  
			@Response.value('(/GeocodeResponse/result/address_component[type="street_number"]/short_name)[1]', 'nvarchar(50)'), PLZ =  
			@Response.value('(/GeocodeResponse/result/address_component[type="postal_code"]/short_name)[1]', 'nvarchar(50)'),city =  
			@Response.value('(/GeocodeResponse/result/address_component[type="locality"]/long_name)[1]', 'nvarchar(50)'), county =  
			@Response.value('(/GeocodeResponse/result/address_component[type="administrative_area_level_3"]/long_name)[1]', 'nvarchar(50)'),Bundesland =   
			@Response.value('(/GeocodeResponse/result/address_component[type="administrative_area_level_1"]/long_name)[1]', 'nvarchar(50)'),Bundesland_kurz =   
			@Response.value('(/GeocodeResponse/result/address_component[type="administrative_area_level_1"]/short_name)[1]', 'nvarchar(50)'),Land =  
			@Response.value('(/GeocodeResponse/result/address_component[type="country"]/long_name)[1]', 'nvarchar(50)'),Land_kurz =  
			@Response.value('(/GeocodeResponse/result/address_component[type="country"]/short_name)[1]', 'nvarchar(50)'),GooglePlaceID =  
			@Response.value('(/GeocodeResponse/result/place_id)[1]', 'nvarchar(255)'),GoogleGlobalCode =  
			@Response.value('(/GeocodeResponse/result/plus_code/global_code)[1]', 'nvarchar(255)'),GoogleCompoundCode =  
			@Response.value('(/GeocodeResponse/result/plus_code/compound_code)[1]', 'nvarchar(255)'),GoogleStatus =  
			@Response.value('(/GeocodeResponse/status)[1]', 'nvarchar(20)')+@partial_match, AnlegeDatum = CURRENT_TIMESTAMP where Adress_ID = @AdressID  
		end
		else -- Eintrag noch nicht da
		begin
			insert into TBL_Adressen_Geocodes (Adress_ID,lat,lng,formatted_address,street,street_number,PLZ,city,county,Bundesland,Bundesland_kurz,Land,Land_kurz,GooglePlaceID,GoogleGlobalCode,GoogleCompoundCode,GoogleStatus) Values
			(@AdressID,@Response.value('(/GeocodeResponse/result/geometry/location/lat)[1]', 'numeric(18,9)'),  
			@Response.value('(/GeocodeResponse/result/geometry/location/lng)[1]', 'numeric(18,9)'),  
			@Response.value('(/GeocodeResponse/result/formatted_address)[1]', 'nvarchar(255)'),  
			@Response.value('(/GeocodeResponse/result/address_component[type="route"]/long_name)[1]', 'nvarchar(50)'),  
			@Response.value('(/GeocodeResponse/result/address_component[type="street_number"]/short_name)[1]', 'nvarchar(50)'),  
			@Response.value('(/GeocodeResponse/result/address_component[type="postal_code"]/short_name)[1]', 'nvarchar(50)'),  
			@Response.value('(/GeocodeResponse/result/address_component[type="locality"]/long_name)[1]', 'nvarchar(50)'),  
			@Response.value('(/GeocodeResponse/result/address_component[type="administrative_area_level_3"]/long_name)[1]', 'nvarchar(50)'),  
			@Response.value('(/GeocodeResponse/result/address_component[type="administrative_area_level_1"]/long_name)[1]', 'nvarchar(50)'),  
			@Response.value('(/GeocodeResponse/result/address_component[type="administrative_area_level_1"]/short_name)[1]', 'nvarchar(50)'),  
			@Response.value('(/GeocodeResponse/result/address_component[type="country"]/long_name)[1]', 'nvarchar(50)'),  
			@Response.value('(/GeocodeResponse/result/address_component[type="country"]/short_name)[1]', 'nvarchar(50)'),  
			@Response.value('(/GeocodeResponse/result/place_id)[1]', 'nvarchar(255)'),  
			@Response.value('(/GeocodeResponse/result/plus_code/global_code)[1]', 'nvarchar(255)'),  
			@Response.value('(/GeocodeResponse/result/plus_code/compound_code)[1]', 'nvarchar(255)'),  
			@Response.value('(/GeocodeResponse/status)[1]', 'nvarchar(20)')+@partial_match )  
		end
	end try
	Begin catch
		if @GeocodeID > 0
		begin
			Update TBL_Adressen_Geocodes set GoogleStatus = 'SQL Fehler' where Adress_ID = @AdressID  
		end
		else
		begin
			insert into TBL_Adressen_Geocodes (Adress_ID,GoogleStatus) Values (@AdressID,'SQL FEHLER')  
		end
	end catch	
	
END