Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!news-lond.gip.net!news-raspail.gip.net!news.gsl.net!gip.net!grolier!usenet-fr.net!proxad.net!216.239.36.134.MISMATCH!postnews.google.com!i39g2000cwa.googlegroups.com!not-for-mail
From: "Mark D Powell" <Mark.Powell@eds.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Create trigger syntax
Date: 4 Apr 2006 07:01:32 -0700
Organization: http://groups.google.com
Lines: 10
Message-ID: <1144159292.773079.211190@i39g2000cwa.googlegroups.com>
References: <2xrYf.442$Es3.134@newsread3.news.atl.earthlink.net>
NNTP-Posting-Host: 192.85.50.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1144159297 24007 127.0.0.1 (4 Apr 2006 14:01:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 4 Apr 2006 14:01:37 +0000 (UTC)
In-Reply-To: <2xrYf.442$Es3.134@newsread3.news.atl.earthlink.net>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: i39g2000cwa.googlegroups.com; posting-host=192.85.50.1;
   posting-account=J7QqBQwAAABTieek3RP_669Gs2iATWzr
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:126382

Why didn't you post what you have and the Oracle error message you are
getting?

A working before insert or update trigger can be seen in the following
cooperative FAQ article:
Is there a way to get the Date/Time when a row was last updated?
	http://www.jlcomp.demon.co.uk/faq/mod_time.html

HTH -- Mark D Powell --