Function in Apex which returns the path of a file?
818365Dec 1 2011 — edited Dec 6 2011Hi
I have many files spread across many servers.
At the moment we handle them with an excel-sheet. All links to these files can be found there.
To improve the handling I would like to use my APEX Application instead of Excel.
-> The files must remain on the servers -> No BLOB-Upload
-> We need a link collection to the files
-> The Oracle database HAS NO rights to access the drives. The local user HAS rights to access the drives.
My goal: A Button which does:
- When pressed: open "Open File"- Window
(( User browses and selects a file ))
- Display the link/path to the file in the textfield P41_LINK_TO_FILE
- Save this link/path as new entry into my link table (well, I won't need help with this step ^^ )
If this button worked I could display these links in an interactive report and use "right-click"->"save file as" etc.
Question:
Is is possible at all to get this "magic button" work?
I feel a little lost. Has anybody some words I could google?
Many thanks for reading!
pAT
Edited by: pAT on Dec 1, 2011 5:00 AM