This example invokes an RPC/encoded Web method to display the exchange rate between two currencies.
Use the add option of sp_webservices to map Web methods to proxy tables:
1> sp_webservices 'add', 'http://www.xmethods.net/sd/2001/CurrencyExchangeService.wsdl' 2> go
The Web method getRate is mapped to a proxy table of the same name.
Invoke the Web method by selecting from the proxy table:
1> select * from getRate where _country1 ='usa' and _country2 = 'india' 2> go
The results returned for the previous select show the exchange rate for the specified parameters:
Result _country1 _country2 43.000000 usa india (1 row affected)
