Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: archving files stored in utl_file_dir

    is there any standart method or package to create archive files that resides in utl_file_dir from pl/sql block?

    i.e. i need to write a procedure that can make an archive from files somewhere in server-side.


  2. #2
    Join Date
    Sep 2003
    Virginia, USA
    Lookup using PlsExtProc to call a registered library. This allows your PL/SQL program to call external programs directly, provided they are registered with your database. There's a known security hole related to ExtProc, so checkout Oracle Metalink for more info.

    A poor man's alternative is to use the UTL_FILE package to write your commands to a text file on the server, such as a file named my_commands.bat on Windows. Then use Windows Task Scheduler to run that file periodically. Nearly identical solution on Solaris.
    Author, Oracle Database 10g: From Nuts to Soup

Posting Permissions

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