Posting SOAP from Oracle

a sample code would be handy

Hi,

Yes, you can use UTL_HTTP for this. Just search the terms "soap utl_http" with your preferred search engine and you will find results like, e.g. https://wiki.scn.sap.com/wiki/display/XI/Triggering+webservice+from+Oracle+Database+with+UTL_HTTP+supplied+package.

Basically, it's about opening the connection (utl_http.begin_request), setting the right headers (utl_http.sending the soap xml (utl_http.set_header) , writing the xml to the webservice (utl_http.write_text) and finally receiving the result (utl_http.get_response). Especially for the sending and receiving there are several flavours of the procedures and functions (writing plain text or writing raw, using a procedure or a function receiving the http-response-codes, receiving a VARCHAR2 or RAW, in one chunk or several chunks). Just check the utl_http-documentation (https://docs.oracle.com/database/121/ARPLS/u_http.htm#ARPLS070 for 12.1).

Be aware that, if you use https you also might need to implement the oracle wallet and include the certificates in the wallet (including the site certificate up to 11.0.4, only the root and intermediate certificates in 12.1 upwards)

I think, the above link and the docs should be a goot point to get you started on this.

Best wishes
Markus

Thanks Markus.

I've managed to get it working using the example for the link you had posted. I was missing 'Content-Type' header in my code.

The next part of my development is to create a webservices server, to allow consuming of  APIs.

In this topic https://www.experts-exchange.com/questions/21326948/Make-a-SOAP-Call-using-an-Oracle-Stored-Procedure.html
there is a sample code and instruction how it can be achieved using jdev, which is good. However, this post is from 2005 and it worries me a bit. Nowadays there might be a better way of doing it.
What's your view on this, please ?

Regards,

Mat