Called Web Services from a stored prcedure

Hello,
Does anyone know if it is possible to call a web service from a stored
procedure? Failing that is it possible to use exterbal object? I'm thinking
along the lines of:
@.obj = CreateObject("xyzzy.f")
@.obj.j = 1
call @.obj
Is this wishful thinking ?
Many thanks...
MartinI'm certain there are multiple methods of doing exactly what you ask, and
each method will impact the performance and reliability of your database to
one degree or another. The best option would be to make the procedure call
and web service call in tandem from the application or a DTS package.
"Martin Waller" <martinwaller@.beeb.net> wrote in message
news:eDWb629MGHA.1716@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Does anyone know if it is possible to call a web service from a stored
> procedure? Failing that is it possible to use exterbal object? I'm
> thinking along the lines of:
> @.obj = CreateObject("xyzzy.f")
> @.obj.j = 1
> call @.obj
> Is this wishful thinking ?
> Many thanks...
> Martin
>|||Thanks for the reply. Performance is not an issue for me. I need to unit
test some web services that directly effect database tables and I was
thinking of a simple .SQL file that does something like:
set-up precondition
call web service
test data is in the expected state
exit
Then I could log the output to a file and, once happy, use it to compare
against in further tests as and when the web serices are tested.
Martin
"JT" <someone@.microsoft.com> wrote in message
news:O$O3O$9MGHA.3932@.TK2MSFTNGP09.phx.gbl...
> I'm certain there are multiple methods of doing exactly what you ask, and
> each method will impact the performance and reliability of your database
> to one degree or another. The best option would be to make the procedure
> call and web service call in tandem from the application or a DTS package.
> "Martin Waller" <martinwaller@.beeb.net> wrote in message
> news:eDWb629MGHA.1716@.TK2MSFTNGP10.phx.gbl...
>|||i recommend you use a sql statement to call a dts, (plenty of examples how t
o
do this). Let the dts call the web service and log whatever it needs to log