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

    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
    If you are on Oracle 10g you are able.
    Check out

    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
    Reading, UK
    On 9i you can create a java stored procedure which can execute any OS command (which can be called from plsql). Look on for more info.


Posting Permissions

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