Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    51

    Unanswered: bat file invokation from oracle procedure

    hi all,

    can i execute a bat file from oracle stored procedure ?

    we can use host command from the sql prompt, but from
    oracle procedure how can i execute the "bat file" or "os commands"?

    please help.

    thanks in advance

  2. #2
    Join Date
    May 2006
    Posts
    7
    If you are on Oracle 10g you are able.
    Check out http://www.databasejournal.com/featu...le.php/3365371

    If you are not on Oracle 10g I have heard (never tried) you can execute a command through TNS and EXTPROC. I can not recomend any resources as i have not tried this approach but you can quickly do a search on the net for 'execute tns listener external extproc' and get some hits.

  3. #3
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    On 9i you can create a java stored procedure which can execute any OS command (which can be called from plsql). Look on asktom.com for more info.

    Alan

Posting Permissions

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