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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL trigger

Re: PL/SQL trigger

From: Saad Ahmad <saad.ahmad_at_mchugh.com>
Date: 17 Apr 1998 23:33:19 GMT
Message-ID: <01bd6a59$2e136ae0$2207030a@sahmad-pc.mfa.com>


Try v$session

sdogiparthy_at_hotmail.com wrote in article <6h84jc$g7r$1_at_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 - 18:33:19 CDT

Original text of this message

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