We are on Apex 22, and I am new to using this tool. We have an interactive report, and in the select statement within the report we want to create a link that when clicked will open up a folder on the windows server.
In oracle forms we use WEBUTIL_FILE to check if the folder exists. Is there anything similar in APEX?
Then we create a .bat file (using CLIENT_TEXT_IO.FOPEN, PUTF, and FCLOSE) in the users c:\temp folder that opens the folder. Is there anything similar in APEX?
Other ways we have thought of to try and get this to work is using the Windows Command Prompt to open the folder (start %windir%\explorer.exe “\\file_path”). Is there a way to execute a windows command prompt from within APEX?