Hi guys,
I have some files located in a shared folder in a windows based server and I want to access them from an APEX5.1 application on a linux server.
I recently upgrade this application from APEX3.2 to APEX5.1 and in the previous version I had a process whitch get the filename from db and used the function below to redirect and display my pdf document in InternetExplorer after a page submit (and it worked fine).
owa_util.redirect_url( '\\\\myWindowsServer\\sharedFolder\\' || fileName)
But in the new version I've got some problems..
I saw that the used function became deprecated in APEX5 so I tried to use this :
apex_util.redirect_url( p_url => '\\\\myWindowsServer\\sharedFolder\\' || fileName );
but Tomcat gave me a 404 error because it attempt to link 'http://linuxServer:8080/myWindowsServer/sharedFolder/fileName.pdf'
I also tried to remove escape characters or change the link as 'file://myWindowsServer/sharedFolder/filename.pdf' but it gave me 'ERR_UNSAFE_REDIRECT' from 'http://linuxServer:8080/apex/wwv_flow.accept'
The file names are saved in the database when the document is created, so it is possible to add the file as a blob in the same time but for existing documents it is problematic because my shared folder already contains thousands of documents so if you have a solution to link theses pdf without insert them all one by one in the database you'll save my life
Thanks for any help (and sorry if my english is not so good)
Florian.