Host command in forms to copy a file
399902Jun 16 2005 — edited Jun 17 2005I am creating a form in 9i I am trying to copy a file from the database machine
to the app server(10g) I am using the following code and nothing is happening.
Please note that I run the same exact copy command from the DOS prompt on the
app server and the file gets copied without any problems - this shows me that
the machines are seeing eachother and the directories are ok.
Here is the code that I am using in a when button pressed trigger of a button
host('copy \\ssidb2\c$\STATS_DYNAMIC_SELECTS\test_results.txt E:\AS\WebTemp');
I also tried this and got the same result.
declare
str varchar2(1000);
begin
str := 'copy \\ssidb2\c$\STATS_DYNAMIC_SELECTS\test_results.txt E:\AS\WebTemp';
host(str,NO_SCREEN);
end;
please advise!