accessing/downloading unix server pdf files from Apex
Hi,
I am hit with another huge challenge here. there is a system which creates tons of PDF files on the UNIX oracle server then these files are loaded into oracle table as blob data. Now ive Apex page which provides links to these pdf reports and allow users to download and save locally into their systems.
Now my biggest issue is that when files are created on the UNIX server directory mapped to oracle directory object when you open these files/download from Apex they are corrupted and cannot be read. Is there a way pdf files can be directly loaded into oracle table as BLOB without using oracle directory object...any suggestion/solution to this issue please?
Oracle 11g&Apex 4.1.1x