For now we’ll keep things simple and use Oracle Stored Procedures to communicate between E2E Bridge and the customer’s Oracle based ERP system.
However, I have another question in this regard:
Our plan is to define a stored procedure that accepts a CLOB data-structure as input. This CLOB will contain an XML message. Now this XML Message can potentially grow quite big: some 10-50MB would not be surprising. The number of calls will be very low (e.g. 1 per week) and the throughput time is not critical.
Are there any problems foreseeable, or is it worth a try?