Hi,
I am trying to upload a file into apex_application_temp_files. While one file uploaded successfully, an exactly similar file with everything same in terms of columns except for data refuses to upload. I have tried dumping out the contents of apex_application_temp_files after file upload but it seems to have nothing in it
insert into fsh_file_upload(load_date, tag_id, species, fish_id, tagger, weight, recapture, fork_length,
genetic, cf, scale, capture_condition, severity, pass, gps_location, notes)
select col001, col003, col004, col006, col007, col009,
col010, col011, col012, col013, col014,
col015, col016, col023, col022, col020
from apex_application_temp_files f,
table(
APEX_DATA_PARSER.parse(
p_content => f.blob_content,
p_file_name => f.filename,
p_add_headers_row => 'Y'
)
)p
where f.name = :P260_FILE;
I am lost as to how to debug this . Any feedback appreciated !