APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to open a file system file from apex interactive report

939073May 29 2012 — edited Aug 30 2012

I have an interactive report that is listing error logs from many different databases. The files are stored in a directory in the file system. They are parsed and information about the file is loaded into a database table. The information loaded into the table is the database name, date run, fail or succeed, and a column in the table contains the directory and the file name. (file_name)

i.e. /appdata0/logs/datapump/database1.log

The apex interactive report list the date the log was created, if there was an error message in the file, and the file name, which is the example above.

I would like to be able to make the file_name column such that I can click on the name and it will open the file from the file system with an app like "note pad" or "word pad" so it can be looked at.

I have seen this done before, but I am not sure how to set up the "Column Link" to make this happen.

Can someone help?