Consuming webservice using utl_http
179992Mar 6 2009 — edited Jul 7 2009Our software is all pl/sql based (10g) and runs using the mod/plsql package in apache using htp.p calls.
I need to consume an external web service but have no experience of doing this or any experience using soap.
I think the best way is going to be using the utl_http package as I want to be able to do this from pl/sql and do not want to use java and then presumably use the xmldom package to read the XML
I'm familiar with the xmldom package and have used that before but I've not really used the utl_http package in this soap sort of way! I assume I would use something like utl_http.request to call the web service?
The WSDL is this : https://www.lettingref.co.uk/webservice/lettingrefapi.asmx?WSDL are there any tools in oracle to allow me to build the client quickly in pl/sql?
Am I going about this in a reasonable way (bearing in mind I want this in pl/sql)?
Thanks in advance
Robert