Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Store XML SOAP Payload in Oracle CLOB/BLOB

User_INSMQJan 1 2023

Is it possible, to store the entire XML Payload of a SOAP request that calls an Oracle XML DB Web Services into a CLOB field into an XX_WS_LOG table? In fact , this is all I want the web service to do; when a third party calls the webservice, the XML is stored in a table, and a "Success" message is sent back if the insert commits, or "Error" with the PL/SQL error, if it fails. Not trying to "select" query any existing table to get record details, only insert into the logging table?
If this is possible, any advice would be greatly appreciated. Using 19C.
Apologies if this is a newbie question and thanks in advance for your help.

Kind regards,

Comments
Post Details
Added on Jan 1 2023
0 comments
643 views