Transfer of flat file from Oracle to SAP from ABAP code

Hi Expert,

I have to write a code in ABAP that call the Oracle procedure and it transfer the file generated by Oracle procedure. To call the Oracle procedure from ABAP with passing multiple parameters that i know the syntax but how to transfer the flat file (output file in txt format) generated by Oracle Procedure?

If any one have sample code can you please give me.

*Note: Oracle procedure is running in the different sever (Legacy system)*

Help is appreciated.

Thanks

Ritesh