I noticed that when I load a csv file generated through OIC, place it in a bucket and pull it to ATP using DBMS_CLOUD.COPY_DATA method, the csv file is always missing the first value row (second row). I am using skipheaders value 1 for 'format => json_object('type' VALUE 'CSV')'.
My csv file is something like this:
Row1: date,invoice,comment
Row2: 12/02/2026,354,'Successful'
Row3: 12/03/2026,457,'Successful'
The DBMS_CLOUD.COPY_DATA is skipping both row1 and row2 when I set skipheaders as 1 and skips no rows when I set skipheaders as 0. The csv file doesn't contain BOM. I am not sure where this went wrong.
When I download the file to my system and upload it to object storage to try the DBMS_CLOUD.COPY_DATA, it only skips row1 for skipheaders as 1. I am guessing something is wrong with my file format but I can't pinpoint it. Can anyone help me with it?