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 := '''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 ');
-- 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!
Thanks for the suggestion, that was a variant I hadn't tried but same result. Please Acknowledge pop up then an ora-06503.
Interestingly this time I repeated the action without closing the test form first and got a WebUtil error.
WebUtil Error: oracle.forms.webutil.host.Host bean not found. WEBUTIL_HOST.Execute will not work. I will not scour forums for this error as well, but perhaps a library isn't attached correctly? I added the webutil library and it seemed to find it and compile fine. I did remove the path when attaching.
If anyone understands the root cause of these or has found a solution I'd greatly appreciate the help. Thanks!