Re: Moving Files Via Oracle Procedure

As far as I see it, your options are:

1. UTL_FILE can move files using FRENAME. You need to have a directory object for each location referenced.

http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/u_file.htm#i1003602

2) You can call a script or command to do the move (sounds like this is what you are doing):

http://www.oracle-base.com/articles/8i/shell-commands-from-plsql.php

3) You can use the Java file API to manipulate the files from PL/SQL, rather than a shell script.

http://www.oracle-base.com/articles/8i/file-handling-from-plsql.php

4) You could set up an external job using the scheduler to perform an OS command.

http://www.oracle-base.com/articles/10g/scheduler-10g.php

Each of these have their pros and cons.

Cheers

Tim...

On Tue, May 8, 2012 at 8:32 AM, Abhishek Gurung <abhishek.gurung_at_hotmail.com> wrote:
> Hi,
>
> I am parsing text, XML files and loading it into the database after that I need to move these parsed file to complete folder.
> I need help in moving these files to complete folder currently I have created a java procedure which helps me run system/OS commands in PL/SQL
> but it is not moving all the files and it is getting stuck in the mid of the operation.
> Please suggest me different options by which I can move files from source to destination directory.
>
> Regards
> Abhishek
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l