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: Lock with dbms_alert

Re: Lock with dbms_alert

From: victor <victor_at_PERCOMBANK.KIEV.UA>
Date: 12 Jan 1999 11:15:16 GMT
Message-ID: <01be3e1c$80560500$cd14abcc@victor> 






Can someone explain me how to use dbms_alert and the role
of the commit with this use ?


--- alert signal you can receave only after commit sender session





Can we used dbms_alert in a trigger ?


-- yes



Can we replace dbms_alert by dbms_pipe, the goal is only to
advertise a process to do something ?




Received on Tue Jan 12 1999 - 05:15:16 CST












Original text of this message













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