Hi
I am getting above error in test instance while running my page . This Apex page works fine in development. While putting trace by inserting in temporary table for test purpose I found in test schema it went to exception
it was not seeing any records in test instance for APEX_APPLICATION_TEMP_FILES
The filename used as file browse with storage type in Table APEX_APPLICATION_TEMP_FILES ,Purge file at end of session file type is select list with a upload button to call a process on submit after computations and validations as below
For test purposes I have put the insert statements
declare
l_filerow APEX_APPLICATION_TEMP_FILES%rowtype;
my_user varchar2(30):=v('app_user');
begin
insert into my_table values('Before process '||:P523_FILENAME);commit; -- This message appears in development and test
select *
into l_filerow
from APEX_APPLICATION_TEMP_FILES
where name = :P523_FILENAME;
myschema.mypackage.myprocedure(iFileType => :P523_FILE_TYPE,
iFilename => l\_filerow.filename,
iFile => l\_filerow.blob\_content,
iCustom2 => my\_user,
iRecipient => 'YYYY',
iFromAPEXYN => 'Y' );
--The below message appears in development as record is found in APEX_APPLICATION_TEMP_FILES and above process called
insert into my_table values('After process '||:P523_FILENAME); commit; --
:P523_FILE_TYPE := null ;
exception
when others then
--The below message appears in test as record is not found in APEX_APPLICATION_TEMP_FILES
insert into my_table values('Exception '||:P523_FILENAME);commit;
end;
Is there a way for me to suggest that this has to do with environment as all corresponding tables etc has been deployed and all priveleges are there and nothing to do with actual process
Screen shot for below in test as well as development
Test
====
Development
===============
Thanks