This discussion is archived
1 Reply Latest reply: Jan 1, 2013 11:33 PM by Marwim RSS

How to run a batch file using tigger....

961076 Newbie
Currently Being Moderated
Hi, i am trying run a batch file using a trigger on a table.
say i have a table XYZ(col_1 varchar2 primary key, col_2 varchar2)
the values of col_2 keeps changing and col_1 are constant
whenever the value of col_2 in any row changes from "on" to "off" i want to run a batch file C:\Users\ABC\Desktop\test.bat

i did some searching but couldn't find any solution. Thanks in advance

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production


sorry wrong foum to post.
will post in the correct one

how to run batch file using trigger?
  • 1. Re: How to run a batch file using trigger
    Marwim Expert
    Currently Being Moderated
    Hallo,

    welcome to the forum.

    This is the forum for the tool {forum:id=260}. Your question should be placed in {forum:id=75} or {forum:id=61}.
    When you post your question there please provide additional information like db version, what kind of trigger you want to use, how you want to prevent the execution when the transaction is rolled back... {message:id=9360002}

    Regards
    Marcus

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points