when calling web-service from Sql Server 2008 R2 it return Null

See more:

SQL-Server-2008R2

when i call web service from sp in sql 2008 r2 it return Null

Ole Automation Procedures-->>true

create Procedure callWebServices(
@param1 Varchar(8000)=null
)
AS
BEGIN TRY
 Declare @Object as Int;
Declare @ResponseText as Varchar(8000);
Declare @Url as Varchar(8000);
set @Url='http://localhost/service/Service1.asmx/HelloWorld'

 print(@Url)	

Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'get',@Url,'false' 

Exec sp_OAMethod @Object, 'send'
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT

print('output'+@ResponseText)
 
Select @ResponseText
 
Exec sp_OADestroy @Object

END TRY
BEGIN CATCH
    SELECT 
        ERROR_NUMBER() AS ErrorNumber
       ,ERROR_MESSAGE() AS ErrorMessage;
END CATCH

Plz advise.