Hello Experts,
I am trying to upload a file via File Browse item (P2_ATTACHMENT)
File Browse item has Storage Type: Table apex_application_temp_files
I'm using Page process to upload file to local table from apex_application_temp_files
It is not working.
My Process has following code in it:
BEGIN
for c1 in (select *
from apex_application_temp_files
where name = :P2_ATTACHMENT)
loop
select email_attachments_seq.nextval into p_primary_id from dual;
insert into EMAIL_ATTACHMENTS (
ATTACHMENT_ID,
FILENAME,
ATTACHMENT,
ATTACHMENT_DESCRIPTION,
MIMETYPE)
values (
p_primary_id,
c1.filename,
c1.blob_content,
NULL,
c1.mime_type);
end loop;
:P2_ATTACHMENT := null;
Execution does not go inside the loop, I checked, I assume because there is nothing in apex_application_temp_files.
What could be wrong
Process is called via Ajax. I can't submit page because it's an email modal, which has to stay opened.
We are on Apex 19.1
Thank you