Re: Trigger syntax?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 07 Dec 1999 21:34:04 +0800
Message-ID: <384D0CCC.A7C@yahoo.com>

Danilo Unite wrote:
>
> Hi,
>
> I get an 'invalid operator' error from the when clause of the following
> trigger:
>
> create or replace trigger delete_mapaddress
> before update of status
> on callforward_profile
> for each row
> when (:new.status = 0)
> begin
> delete from mapaddress
> where subscriber_id = :new.subscriber_id
> and callflow_id = :new.callflow_id
> and graphnode_id = :new.graphnode_id;
> end;
>
> I guess it has to do with the use of :new.status in the when clause.
> What am I doing wrong? Should I be doing this another way? Any help
> would be greatly appreciated.
>
> Thanks in advance,
> Danilo
>
> ---------------------------------------------------------------
>
> Name: danilo.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Danilo Unite

No colon in the 'when'

when ( new.status = 0)
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Dec 07 1999 - 07:34:04 CST