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.
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
24 freelanceria on tarjonnut keskimäärin 378 $ tähän työhön
Hi! We have a vast experience in Oracle PL/SQL under 9i and 10g databases, Forms 6i / 9i and Java application and we'll be glad to help you with the project. Regards, George