Problem using CLIENT_HOST from webforms.
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