Calling a web service using UTIL_DBWS

Hi All,

I am calling a web service using a package UTIL_DBWS. I am new in calling a web service from PL/SQL Function. So, i started with the small and standard web service. This web service converts the Temperature from Celsius to Fahrenheit. I got this code from internet.

CREATE OR REPLACE function APPS.XXAD_TEST_CALL_WS(temperature NUMBER) RETURN VARCHAR2 AS

service_ utl_dbws.SERVICE;

call_ utl_dbws.CALL;

service_qname utl_dbws.QNAME;

port_qname utl_dbws.QNAME;

response sys.XMLTYPE;

request sys.XMLTYPE;

BEGIN

utl_dbws.set_http_proxy('myproxyserver:8080');

service_qname := utl_dbws.to_qname(null, 'CelciusToFahrenheit');