Thread: HOST command not working

hi try something like this. client_host ( 'cmd /C start c:\a.mp3'); else message ( 'error' ); end if; end; Sarah Edited by: S@R@h on Nov 5, 2009 2:30 AM

Hi! Please show us your code. May the host command is not beeing closed. try something like: host ( 'cmd /C your_command' ); Regards

host('C:\javasoft10g\jre\bin\javaw -classpath C:\javasoft10g\jre\libt.jar;'||afile||';'||vfile|| ' ecscClient ' ||vtmmm||' '|| vwall ||' '||vusrname|| ' ' || '0' || ' ' ||TO_CHAR(vnum)||' '||v_rmi_ip);

do we also need to set a path in default.env???

May it would be easier to create a batch file and call that with the host command. host ( 'cmd /c batchfile.cmd' ); to check if the environment is proper set when your host command is running create a textfile with: host ( 'cmd /c set > c:\env.txt' );

host('C:\javasoft10g\jre\bin\javaw -classpath C:\javasoft10g\jre\libt.jar;'||afile||';'||vfile|| ' ecscClient ' ||vtmmm||' '|| vwall ||' '||vusrname|| ' ' || '0' || ' ' ||TO_CHAR(vnum)||' '||v_rmi_ip); In case of dynamic string population, it is strongly recommanded to output the result of the string to understand the issue. Else, you are going to ...

Hi, Try this. declare v_command varchar2(1000); begin ... ... v_command : = 'C:\javasoft10g\jre\bin\javaw -classpath C:\javasoft10g\jre\libt.jar;' ||afile|| ';' ||vfile|| ' ecscClient ' ||vtmmm|| ' ' || vwall || ' ' ||vusrname|| ' ' || '0' || ' ' ||TO_CHAR(vnum)|| ' ' ||v_rmi_ip; Message(v_command); Message ( ' ' ); -- ====> Make sure you the ...

ok when i use host('cmd /c set > c:\env.txt'); it creates a file on the server which means that the paths are set. Now to run the requried file i did as: host('cmd /C:\javasoft10g\jre\bin\javaw -classpath C:\javasoft10g\jre\libt.jar;'||afile||';'||vfile|| ' ecscClient ' ||vtmmm||' '|| vwall ||' '||vusrname|| ' ' || '0' || ' ' ||TO_CHAR(vnum)||' '||v_...

From the command prompt, if you run C:\javasoft10g\jre\bin\javaw -classpath C:\javasoft10g\jre\libt.jar;C:\javasoft 10g\paths;;C:\javasoft10g\paths\dusjava.jar; ecscC lient 1709353 E DUS 0 0 192.168.100.141 Are you able to run without any errors? -Arun

Arunkumar Ramamoorthy wrote: From the command prompt, if you run C:\javasoft10g\jre\bin\javaw -classpath C:\javasoft10g\jre\libt.jar;C:\javasoft 10g\paths;;C:\javasoft10g\paths\dusjava.jar; ecscC lient 1709353 E DUS 0 0 192.168.100.141 Yes when i run this command on server's cmd it works fine