First off I would HIGHLY recommend you update yor apex instance to something more current.. 4.2 I believe is not a supported version at this time.. Second, you want to upload and download documents from the file system versus a database?
Please explain the use case for this, since it would make more sense to store them in the database, unless you have users needing o access them outside your application.
Los Alamos, NM
However my current requirement is to upload to a network drive and download from there.
- Use external files (bfile).
- Make the files available on the webserver and link to the file (for downloads only).
- Use the standard Apex upload functionality to an upload table and write the file to the file system after upload.
On the other hand: what's the specific use if it is on a network drive. Do the users have access to that drive?
This is my employer's installation, They are not ready to upgrade yet. I wish they upgrade too. Right now I have no choice but to work on( i am an employee) . They are storing all their documents in a remote azure server Which is available to the users via other applications. So technically I need only to upload, not download.
Can you give me some guidance.
Sir, thanks for the reply. Would you please give little more details. I am not very advanced in APEX
Would you please give little more details. I am not very advanced in APEX
There is no Apex functionality involved in external files. It is handled via the database e.g. as a BFILE.
Since you are now adding additional information that your files are stored on an Azure cloud server, I think things will change. Can the database access this server? Are there webservices on Azure to handle file transfer?
Now I have PL/SQL procedure the provided by the other team to load the file to Azure cloud. I dont have to worry about that part.
however I need help to load files ( more than one files) and get the file information in a collection and use to call the procedure. With normal file browse can I upload multiple files? How can I get this information to a collection .
1 person found this helpful
I need help to load files ( more than one files)
That's a property of a File Browse item: "Allow Multiple Files"
in a collection
Why a collection? Just use the standard APEX_APPLICATION_TEMP_FILES and process from there. It's more or less the same as a collection (temporary storage).
Allow Multiple FileWhys
Thanks for the reply. My employer's Apex version is 4.2. I don't see any option to " allow multiple files" in File Browse item property . Also in the storage type there are only 2 options. Custom table BLOB or WWV_FLOW_FILES. Will APEX_APPLICATION_TEMP_FILES work with version ?
Thanks for the reply. My employer's Apex version is 4.2. I don't see any option to " allow multiple files" in File Browse item property.
4.2 does not have built-in support for multi-file upload. See if you can find an old 4.2-level plug-in that does.
Also in the storage type there are only 2 options. Custom table BLOB or WWV_FLOW_FILES. Will APEX_APPLICATION_TEMP_FILES work with version ?
APEX_APPLICATION_TEMP_FILES was introduced in APEX 5.0. WWV_FLOW_FILES (aka APEX_APPLICATION_FILES) is the 4.2 equivalent, but you will have to manage the files yourself as they are not automatically purged at request or session level.
Now you are getting some indication of what you are up against when using an unsupported version. Very few people will still have access to a 4.2 installation so they cannot develop and test version-compatible solutions to your problems. A number of forum users who could now be considered "experts" have no experience with anything older than 5.x, aren't aware of the differences, and will provide potentially misleading advice.
Your employer may not be "ready to upgrade yet", but I bet that they are quick enough to complain about deficiencies in APEX that do not exist in the current version. I also reckon that this reluctance to upgrade doesn't extend to Windows and Java...
Thanks for your detailed support. I gave my personal concern many times to the employer about upgrade. They are still very slow on this.
One more question.
Thanks a lot
Not on its own. There has to be a server component capable of receiving multiple files.
What web server are you using?