Hi,
I am using the standard apex supplied file browser to upload user files into the database. However, since the users want to upload mulitple files, I have added a javascript function which helps in adding multiple file browsers to the page.
Once the files are selected and the submit button is clicked, all the selected files are being loaded into the table
wwv_flow_file_objects$.
But all the files are not showing up in the view
apex_application_files.
Very specifically, only the first file does not show up in
apex_application_files.
On checking the table
wwv_flow_file_objects$,
I found that the security group id is not being set uniformly for all the uploaded files.
The files which have security group id as 0 are visible in the view
apex_application_files.
So is there any way that I can set the security group id to zero or a uniform value for all the files being loaded ?
I have tried creating an after header process which invokes
WWV_FLOW_API.SET_SECURITY_GROUP_ID;
but thats not helping at all.
So if anybody could please provide some suggestions?
Thanks
Rishi.