run executable program from oracle trigger ( or procedure)

[abuasab]

how can run executable application from oracle trigger or procedure.

[Pilgrim333]

Hi,

What is it exactly that you are trying to do?

Pilgrim.

[abuasab]

i need to run external program myprogram.exe with passing parameters

from example ,
in tirgger of table level , i check some columns if it is statisied my condition , then i need to run my program.exe

[Pilgrim333]

Hi,

Is it ok if you execute it using shell commands? (On a windows machine, executing it by giving the dos commands for it)

Pilgrim.

[amitpatel66]

1.Create a shell that calls oracle procedure
2.In oracle procedure, do your required condition check.
3.In case if the check satisfies, then call or execute your external program from shell.