Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Is it possible to recover the SQL statement that invoked trigger

Is it possible to recover the SQL statement that invoked trigger

From: <sdogiparthy_at_hotmail.com>
Date: Fri, 17 Apr 1998 12:45:52 -0600
Message-ID: <6h84gg$g76$1@nnrp1.dejanews.com>


Hi,
  Any one please help me!
My question is:
WITH IN THE BODY OF THE TRIGGER, IS IT POSIIBLE TO RECOVER THE SQL STATEMENT THAT INVOKED THE TRIGGER? Let there are two sets of same databases in two different servers, and whenever there is any change in the first database, it should fire a trigger and this trigger should update other copy also by sending an Email to the other server. please reply me soon..

Sreedhar Dogiparthy..

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 17 1998 - 13:45:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US