Skip to Main Content

SQL & PL/SQL

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!

SOAP service with PL/SQL

user13328581Jun 8 2023

Hello Experts;

I have spent quite a few days reading a bit on SOAP webservice but I don't think i am currently on the right track since I am quite a beginner. I was wondering if it is actually possible to call a SOAP webservice to retrieve a csv file and if so, can someone please help guide me.

I studied forum briefly on a similar question but i have more questions than answer from it

https://forums.oracle.com/ords/apexds/post/call-web-service-multipart-mime-soap-request-using-pl-sql-u-0544

Question 1

there was a begin http request, however why was the header set and was this information provided

Question 2

there was an http response, but it was returned as a clob, would it be possible to convert the clob as a csv file to save it on the oracle server

Comments
Post Details
Added on Jun 8 2023
6 comments
621 views