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 -> View SQL in trigger

View SQL in trigger

From: David Kaiser <davidk_at_sfmic.com>
Date: 1996/12/05
Message-ID: <32A6DBBB.77A9@sfmic.com>#1/1

Is there a way to grab the SQL statement that is being processed in a trigger? In other words if I do a "update foo set thing = "dog" where type = "animal" and the update trigger fires on foo, can I somehow capture the SQL statement that caused the trigger to fire?

-- 

+---------------------------------------+-------------------------------+

| David Kaiser | e-mail: davidk_at_sfmic.com
|
| Project Manager | WWW: http://www.sfmic.com
|
| State Fund Mutual Insurance Company |
|
| 7500 Flying Cloud Drive, Suite 900 | voice: 612.914.1317
|
| Eden Prairie, MN 55344 USA | fax: 612.944.1169
|
+---------------------------------------+-------------------------------+
Received on Thu Dec 05 1996 - 00:00:00 CST

Original text of this message

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