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_at_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_at_havelsan.com.tr"
title=bunyamink_at_havelsan.com.tr>Bunyamin K. Karadeniz
To: <A href="mailto:ORACLE-L_at_fatcity.com"
title=ORACLE-L_at_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
Received on Mon Jul 02 2001 - 03:01:44 CDT
