UTL_FILE execute OS file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: UTL_FILE execute OS file

  1. #1
    Join Date
    Feb 2005
    Location
    Luxembourg
    Posts
    28

    UTL_FILE execute OS file

    Hi,

    is it possible to execute an external file (*.bat which will call a PHP Programm) with UTL_FILE?

    If not, any idea how i could do that?
    Oracle Version: 9.2.0.1.0
    OS Client & Server: Windows XP Pro

  2. #2
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    No, UTL_FILE only reads and writes files. You would have to execute your script from outside of PL/SQL or by running a small JAVA program.

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    As Scorby says it can be done with Java - as usual Tom Kyte has answered this (keep reading, it does cover Windows too):
    http://asktom.oracle.com/pls/ask/f?p...A:952229840241
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

Posting Permissions

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


Click Here to Expand Forum to Full Width