From bunyamink@havelsan.com.tr Wed, 27 Jun 2001 08:09:38 -0700
From: "Bunyamin K. Karadeniz" <bunyamink@havelsan.com.tr>
Date: Wed, 27 Jun 2001 08:09:38 -0700
Subject: EXECUTING DOS COMMAND IN A STORED PROC?
Message-ID: <F001.00339F04.20010627070730@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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  <FONT face=Arial 
size=2>C:\file_name.txt D:\file_name.txt;
end;
/
 
But does not recognize COPY command 
here.
How can I do that??
 
Thank you