3 Replies Latest reply: Nov 22, 2012 1:48 AM by Christian Erlinger RSS

    Problem using CLIENT_HOST from webforms.

    user13842793
      Greetings,
      I am trying to use CLIENT_HOST to open up ie and display an .htm page. When the form gets to the client_host call it displays a Please Acknowledge message, I click okay then shows an error FRM-40735 WHEN-MOUSE-DOUBLECLICK trigger raised unhandled condition exception ORA-06503. This exception says a function failed to return a value. I used messages to walk through the form so I know the error pops when the client_host is issued. I have tried moving several incarnations of the call listed below. I've searched several forums but although I saw several similar threads could not find one that outlined the problem or found a solution. Any direction or help would be greatly appreciated.

      DECLARE
           file_loc VARCHAR2(100);
           pid WEBUTIL_HOST.PROCESS_ID;
      BEGIN
           file_loc := '''cmd /c START "C:\Program Files\Internet Explorer\iexplore.exe" "K:\COMMON\ITS\RPM.htm"''';
      -- CLIENT_HOST('cmd /c START "C:\Program Files\Internet Explorer\iexplore.exe" ');
      -- CLIENT_HOST('cmd /c START C:\Program Files\Internet Explorer\iexplore.exe ');
      message('file_loc set');
      message('file_loc set');
      CLIENT_HOST(file_loc);
      -- pid := WEBUTIL_HOST.NONBLOCKING_WITH_CALLBACK('CMD /C START "C:\Program Files\Internet Explorer\iexplore.exe" '||file_loc,'HOST_CALLBACK');
      END;

      The lines commented out are some of the things I have tried that did not work. Also the string I am setting file_loc to works on the cmd line.

      Thanks for any help provided, and Happy Thanksgiving!

      Andrew