I want to call a webservice from stored procedure. I am using SQL server 2008.Below is my code.Please guide me in solving the issue

Transact-SQL
4

I have tried the same way to invoke a webservice in a sql and i gain nul. Could anybody tell me what is the problem?
begin
set @sUrl='http://localhost:6745/WebService.asmx?op=converttodaysweb'+'&day='+convert(nvarchar,@paramd)+'&month:'+convert(nvarchar,@paramm)+'&year:'+convert(nvarchar,@paramy)+''
exec sp_OACreate 'MSXML2.XMLHTTP', @obj OUT
exec sys.sp_OAMethod @obj,'Open',null,'GET',@sUrl,false
exec sys.sp_OAMethod @obj,'send',null,''
exec sys.sp_OAGetProperty @obj,'responseXML.xml',@response OUT
SELECT @response [response]
exec sys.sp_OADestroy @obj