hi,
 
i think u should make use of ocopy utility instead of simple copy command. this is provided in oracle_home\bin
 
jsu replace copy with ocopy.
 
Saurabh Sharma
 
----- Original Message -----
Sent: Wednesday, June 27, 2001 8:37 PM
Subject: EXECUTING DOS COMMAND IN A STORED PROC?

Hi gurus,
I want to create a stored procedure to move some files to a different location.
 
CREATE OR REPLACE PROCEDURE  move_file (file_name varchar2) IS
begin
host copy  C:\file_name.txt D:\file_name.txt;
end;
/
 
But does not recognize COPY command here.
How can I do that??
 
Thank you
 

Reply via email to