From ssharma1@fcsltd.com Mon, 02 Jul 2001 01:01:44 -0700
From: "Saurabh Sharma" <ssharma1@fcsltd.com>
Date: Mon, 02 Jul 2001 01:01:44 -0700
Subject: Re: EXECUTING DOS COMMAND IN A STORED PROC?
Message-ID: <F001.0033ECEF.20010702005023@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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
 
saurabh.sh@usa.net<A 
href="http://www.geocities.com/saurabh00pc/stride.html">http://www.geocities.com/saurabh00pc/stride.html
<BLOCKQUOTE 
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  <A href="mailto:bunyamink@havelsan.com.tr" 
  title=bunyamink@havelsan.com.tr>Bunyamin K. Karadeniz 
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@fatcity.com>Multiple recipients of list ORACLE-L 
  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  <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