Re: EXECUTING DOS COMMAND IN A STORED PROC?

2001-07-02 Thread Saurabh Sharma
. Karadeniz To: 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 PROCEDUREmove_file

EXECUTING DOS COMMAND IN A STORED PROC?

2001-06-27 Thread Bunyamin K. Karadeniz
Hi gurus, I want to create a stored procedure to move some files to a different location. CREATE OR REPLACE PROCEDUREmove_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