Unable to load data into multiple table
Hello Support,
I have a requirement where needs to load data from .csv file to multiple table. we have oracle application 12.2 version and 12c database. for this i have creaated following database object.
-- Table creation
create table xxabc.xxabc_cust_bai2_fheader
(
fheader_id number,
record_code varchar2(10),
sender_id varchar2(10),
receiver_id varchar2(10),
creation_date varchar2(10),
creation_time number,
fiid number,
rec_length number,
block_size number,
ver_number number
);
create table xxabc.xxabc_cust_bai2_gheader
(
fheader_id number,
gheader_id number,
record_code varchar2(10),
receiver_id varchar2(10),
origin_id varchar2(10),
status number,
value_date varchar2(10),
value_time varchar2(10),