What is the best approach to insert report data from oracle fusion to Autonomous DB?
Summary:
Hello,
I am trying to insert the data from a report whose output is in XML format using OIC in which SOAP service is called to retrieve data from report and passed as body to a rest service which calls a procedure developed in Apex to decode the payload and insert into table using XML table functionality.
But when the report data exceeds 5MB (not sure exactly what is the limit), error occurs while inserting.
What is the best approach to insert report data from oracle fusion to Autonomous DB?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
0