There is a requirement like this:
(a) A non-Oracle application generates text files and dumps it to server A's hard-drive. These are CSV text files which are generated regularly.
(b) We need to copy these files to the hard-drive in server B every day at a particular time.
(c) Then we use PL/SQL to process these files and transfer the information to Oracle DB tables after doing some transformations and data cleansing. The DB is in another box (Server C).
(d) We also need to know when new files are put to server A.
How can we do all of this in PL/SQL with a simple Oracle Forms control interface.