Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Concurrent program to FTP file from Oracle R12

RoyKCApr 26 2017 — edited Apr 27 2017

Hi Folks,

  I am working in the following Oracle environment:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0

Unix: Linux X86 Redhat Enterprise 4

Oracle Financials: 12.1.3

I created a SQL SELECT statements that GL data from Oracle GL.  I run them in toad and export them to a Windows server as .CSV files.  I need to automate the process so I want create a concurrent program to issue the SELECTS and transfer the data to a Linux Server.  Where can I find an example of FTP to implement the transfer.  It FTP the only option or are there other technologies available.  If there is a better forum please direct me to the right one.

Thank you

Roy

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2017
Added on Apr 26 2017
5 comments
1,704 views