Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OIC- Passing XML file as a argument to a Stored procedure.

edited Jun 10, 2021 5:05PM in Data Integration

Summary

Has any one read a file from a sftp server(ftp connection) and passed the file as a argument to a Stored Procedure on Oracle DB via DB adapter.

Content

Trying to get this to work and want to know if anyone has tried this or if it is possible. I am reading a file form a FTP server (XML file) and in the OIC integration using the Oracle DB adapter to pass this file as a argument. Please advise if anyone if this is even possible on OIC.

 

Thanks,

 

Version

21.2.2.0.0 (210505.1400.40944)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!