This content has been marked as final. Show 3 replies
AFAIK, you have to create an APEX validation (PL/SQL returns Boolean or Returns error text), which will query the file details from apex_flow_files table. Here you can get filetype and size etc.
So just validate and if any validation fails, then delete the file from apex_flow_files and riase error message.
P.S. Please note that, if there are other apex validations on your page and if they fail, still apex will load the file into apex_flow_files table. So it's good idea to create a validation (PL/SQL) which will fire (condition) when inline validation errors occured. Make sure that this is the LAST validation on your page in sequence. And here you can write code to delete the file from apex_flow_files table.
Edited by: Hari_639 on Sep 20, 2012 10:09 PM
Yes, once the page is submitted successfully => file uploaded to apex_flow_files table successfully. And it's available for all after submit actions.
I have requested for new attrbute for file-brose item at [url https://apex.oracle.com/pls/apex/f?p=55447]Oracle Application Express Feature Requests. Hope APEX Team will consider this request :)
Search "Feature Requests" with "New attribute for file-browse item"