3 Replies Latest reply on Nov 22, 2012 7:48 AM by Christian Erlinger

    Problem using CLIENT_HOST from webforms.

      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.

           file_loc VARCHAR2(100);
           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');
      -- pid := WEBUTIL_HOST.NONBLOCKING_WITH_CALLBACK('CMD /C START "C:\Program Files\Internet Explorer\iexplore.exe" '||file_loc,'HOST_CALLBACK');

      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!