Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    Buenos Aires, Argentina
    Posts
    5

    Unanswered: Copying files with PL/SQL

    Can anybody tell me how can I copy and delete plain files with PL/SQL package?. I'm using UTL_FILE built in package but I can't find any function to do this. My server is Windows 2000 and this files are placed on valid "utl_file_dir" directories.

    Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: Copying files with PL/SQL

    Not sure if that is supported. But I imagine you could call an external procedure that ran a batch file or script (ie Perl) do to the copy.

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Copying files with PL/SQL

    In 10G there is UTL_FILE.FCOPY to copy files. and in 9i there is UTL_FILE.FREMOVE to delete files. In earlier versions you would have to write your own Java-based procedures (e.g.) to do this.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Copying files with PL/SQL

    See this link for how to delete files via Java: http://www.unix.org.ua/orelly/oracle...8i/ch09_09.htm

  5. #5
    Join Date
    Feb 2004
    Location
    Buenos Aires, Argentina
    Posts
    5

    Re: Copying files with PL/SQL

    Originally posted by andrewst
    See this link for how to delete files via Java: http://www.unix.org.ua/orelly/oracle...8i/ch09_09.htm
    Thanks, I'm working with Oracle 8i, so I'll try to solve this with a Java procedure.

  6. #6
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    I created an external procedure (in C from code off Oracles site) that creates a batch file that then runs if thats of any use
    There are 10 types of people in the world, those that know Binary and those that don't.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •