4 Replies Latest reply: May 4, 2012 3:30 AM by VC RSS

    Open Windows Explorer with path from IR?

    780097
      Hi.

      Using latest version of APEX on Oracle XE 10.

      I have a database that has fields with UNC paths in. I want to be able to launch Windows Explorer with these paths from an Interactive Report... is this possible?

      Thanks in advance,

      Adam.
        • 1. Re: Open Windows Explorer with path from IR?
          VC
          Hi Adam,

          Since you are on oracle XE edition you won't be able to use the java, the other option is to use the dbms_scheduler.create_job with job_type as EXECUTABLE

          Look at this
          http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_sched.htm#i1000363

          Thanks
          • 2. Re: Open Windows Explorer with path from IR?
            780097
            Hi, and thanks for the response.

            I'm not sure if I've been clear in what I was asking as this seems like overkill at first glance - or maybe I just don't get what's actually involved! ;-)

            E.g. Say my data was

            Analyst : Mr Any Body
            Date: 04/01/2012
            Path: \\server1\vol1\DirA\Subdir1

            I'd like the Path field to appear as a hyperlink that opens Windows Explorer with that path in the address bar. Is this not possible with javascript or something? Even if it is, I need some help with how/where to plug that into my Interactive Report.

            If I used something other than an Interactive Report (e.g. just a regular form), could I code a button to do this task?

            Thanks again,

            Adam.
            • 3. Re: Open Windows Explorer with path from IR?
              Prabodh
              Apex is web environment. Only HTTP/HTTPS allowed, no UNC paths anywhere.

              Regards,
              • 4. Re: Open Windows Explorer with path from IR?
                VC
                Hi Adam,

                You could open the UNC paths using the below JavaScript call

                Internet Explorer
                function test() {
                  window.open('file://server1/vol1/DirA/Subdir1');
                }
                Firefox
                function test() {
                  window.open('file://///server1/vol1/DirA/Subdir1');
                }
                for your requirement you could probably do something like
                a href="javascript:test();">//server1/vol1/DirA/Subdir1</a>
                Thanks