Called Web Services from a stored prcedure

17 Feb 2006 4:17 PM

Martin Waller

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

17 Feb 2006 4:29 PM

JT

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.

Show quote

"Martin Waller" <martinwal***@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
>

17 Feb 2006 4:44 PM

Martin Waller

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

Show quote

"JT" <some***@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" <martinwal***@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
>>
>
>

17 Feb 2006 5:09 PM

marcmc

i recommend you use a sql statement to call a dts, (plenty of examples how to
do this). Let the dts call the web service and log whatever it needs to log