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

Extract the table data (csv format) in ATP Database

Received Response
edited Jan 20, 2022 12:14AM in Autonomous Database 2 comments


Extract the table data (csv format) with some filter criteria in ATP Database


We are using ATP to store the data and do some enrichment before sending to target system.The target systems(non oracle) are accepting the data in csv files only.It needs to be done through  the automated integration program. Hence I am looking for guidance that how  we can achieve the automated way to generate the csv files for a table data (based on some filter criteria).

In the normal DBCS instance, We have access to UTL_FILE which can be called inside the packaged procedure to write the csv file programatically. Is it achievable in ATP ?Just for FYI ... We are using Oracle SOA for orchestrating the process. We will like to use  write file operation on database side due to high volume data and will impact the performance on SOA if we use the SOA for writing the file. 

Howdy, Stranger!

Log In

To view full details, sign in.


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