|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I'm new to the forum - I need help with Oracle Triggers (or Alerts). I have to create an interface that will send data to an external application (Denali) each time table on my system changes.
My main confusion is: how to create an output and how to send it via tcp/ip to the external app. Thanks so much in advance! |
|
#2
|
|||
|
|||
|
there are about a million ways to create triggers...you can do them on dml per object, or even ddl per schema...
here is the basic syntax for dml on a table: CREATE TRIGGER trig1 AFTER INSERT ON Table_name REFERENCING NEW AS newRow FOR EACH ROW WHEN (newRow.a <= 10) BEGIN INSERT INTO T5 VALUES(:newRow.b, :newRow.a); END trig1; my recommendation is hit google til you find exactly what you want. ~jimbag8 |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Help with Triggers - Oracle - Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|