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

    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.

    thanx.

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    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.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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