Extract xml from Oracle Db then reload in another Oracle DB

Summary Process: Note the following takes place using Oracle databases on Windows Client and Server I need a process to poll a database at regular intervals, extract records as separate xml files and post them along with other files named in fields within the database record to a network ‘Receiving’ folder. A second process polls the Receiving folder, picks up the xml file and inserts it into a database. Process Detail Every n seconds, Read Table X, if records are present, extract each record into separate xml files located in a ‘Pending’ folder, one file per record. The xml filename is based on sysdate and a concatenation of columns in the database eg format(sysdate, ‘yyyymmdd’) || X.column_A || X.column_B || ‘.xml’. The record also contains a field containing another filename (X.file_name) which accompanies the xml file. This field containing the filename will also exist within the xml file as it is extracted from the database record. The other file is contained in a folder c:\Ready_to_go\ and is a relatively large file c5Mb Both the xml file and the accompanying file need to be posted/copied to a network folder. Say the folder is called ‘Received’. The Other file must be posted first, the xml file is posted second. Another separate process takes place polling the ‘Received’ folder. It picks up the xml file, based on the file_name tag, the process checks for the existence of the accompanying file, if all is well, the xml data is inserted into another database and both the xml file and the accompanying file will be moved to a ‘Processed’ folder. Write to audit database End of process. Error handling must be carried out throughout the process