Utl_file Q !!
Based on a real time process we have data coming in off an MQ series queue into an Oracle db. which has to be output to ONE extract file in the order received and ftp'd. The data has the format:
C01 ACC_NUM A B C D
C02 ACC_NUM A B C D E F
.
.
C06 ACC_NUM A B C D E F G H
Each of the above will be a column in a table and to be extracted to 1 flat file for ftp.
Questions:-
1. Will one table be a good idea for all the above columns or 6 tables for each
CXX ACC_NUM combo - data has to be output in fixed length format with pre-detmnd. start positions.
2. If 6 tables are designed can the utl_file pkg./procs be used to extract data
from all 6 tables to one file ?
3. As a record is written to the file a column specifically created in the table/s has to be updated to confirm the write(date-time) to the file.
From a coding and performance point what is the best solution ?
TIA
cruser3
Reply With Quote
