We are on APEX 5.1.2. I have a dynamic action I use to attach a file. When I call that DA I get the error:
ajax call returned server error ora-01403: no data found for .
I put this code on apex.oracle.com and it failed as well.
The DA does not execute unless I remove the file browse page item from the Items to Submit field on the PL/SQL step. But then the DA won't find the file I attached.
Here is the PL/SQL step:
declare
l_filerow apex_application_temp_files%rowtype;
l_id number;
begin
pr_error_log('Add Additional Page 18', 'Here');
begin
select *
into l_filerow
from apex_application_temp_files
where name = :P18_ADD_ATTACH;
exception
when others then pr_error_log('Add Additional Page 18', 'File not found in apex_application_temp_files');
end;
insert into table_with_blob (field_list)
values (field_values)
returning id into l_id;
:P18_ADD_ATTACH := null;
exception
when others then
pr_error_log('Add Attach Page 18', sqlerrm);
end;
Items to Submit: P18_ADD_ATTACH