Error on Trigger

[Edis, Bob]

G'day Collin

This is not a PowerHouse error but rather a database error (Oracle Rdb I
assume).  It looks like the trigger is trying to delete a record that has
been locked for a write transaction.  Could it be that the update on the
table has not released the lock before the trigger is trying to delete the
rows?

Regards,
Blue

-----Original Message-----
From: Colin Findlay [mailto:FindlayC@turpinltd.com]
Sent: Monday, October 14, 2002 11:14 AM
To: Powerh-L (E-mail)
Subject: FW: Error on Trigger 


Hi there.

Anybody had this message from a PowerHouse routine?

> Data access error. (SYSTEM_STATUS_TBL*01)
> %RDB-E-TRIG_REQ_ERROR, error encountered by a request using triggers
> %RDMS-E-TRIGNODEL, trigger SS_TBL_TIDY cannot delete record being modified
> or
> stored
> %RDB-F-ON_DB, on database DISK$DRIVE7:[XDS.RDBDATA]XPS_MAIN.RDB;1
>  
> Press RETURN to continue.
> 
This happens when you update SYSTEM_STATUS_TBL such that it falls within the
confines of the following trigger:

>  
>  SQL> show trigger ss_tbl_tidy
>      SS_TBL_TIDY
>  Source:
>         SS_TBL_TIDY
>                      AFTER UPDATE ON
>                         SYSTEM_STATUS_TBL
>                         (
>                         DELETE FROM
>                                 SYSTEM_STATUS_TBL
>                         WHERE
>                      !          DATE_AMENDED <= CAST(CURRENT_DATE -
> INTERVAL '12' MONTH AS DATE ANSI)
>                                 DATE_AMENDED <= CAST(CURRENT_DATE -
> INTERVAL '1' YEAR AS DATE ANSI)
>                         )
>                         FOR EACH ROW 
> 
> 
 .
Regards,
Colin
>  
>  

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.