RE: Advance Oracle Trigger Writing Advice

From: Remacle Jean <Jean.Remacle_at_winterthur.be>
Date: Mon, 17 Jun 2002 22:48:19 -0800
Message-ID: <F001.0047FF56.20020617224819@fatcity.com>

Hi Hanna,

If you are running 8I and up you can use autonomous transactions. Which permits you to commit a procedure without affecting the calling procedure's transaction status.
Meaning that you can commit a debuging/tracing record before hitting the commit in the calling trigger.

And the best guidelines I found was in one of Feurerstein's book.

Jean Remacle

		-----Original Message-----
		From:	johanna.doran_at_sungard.com
[mailto:johanna.doran_at_sungard.com]
		Sent:	lundi 17 juin 2002 20:43
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: Advance Oracle Trigger Writing Advice

		Hi Chris,

		Thanks,

			But unfortunately I only can see the error when the

record is inserted using a third party replication product. Even then, if I restart replication, then the record gets processes without error. I was hoping to somehow step through the trigger every time it was fired, regardless of what session or process cause it to fire.

                Thnaks,

                        Hannah

> -----Original Message-----
> From: root_at_fatcity.com_at_SUNGARD On Behalf Of
"Grabowy, Chris" <cgrabowy_at_fcg.com>

> Sent: Monday, June 17, 2002 2:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Advance Oracle Trigger Writing Advice
>
> I don't have any of that, but I was just wondering if you
knew that you can

> use DBMS_OUTPUT in a trigger? Which obviously can be
helpful when debugging

> a trigger.
>
> As for best practices, I would look at Steve Feuerstein's
books. Or his

> best practices presentation, etc can be found at
> http://www.quest-pipelines.com/.
>
> HTH
>
>

		-- 
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		-- 
		Author: 
		  INET: johanna.doran_at_sungard.com

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists         

---

                To REMOVE yourself from this mailing list, send an E-Mail message

                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

		the message BODY, include a line containing: UNSUB ORACLE-L
		(or the name of mailing list you want to be removed from).
You may
		also send the HELP command for other information (like

subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Remacle Jean
  INET: Jean.Remacle_at_winterthur.be

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jun 18 2002 - 01:48:19 CDT