Home » SQL & PL/SQL » SQL & PL/SQL » Re: Mutating Trigger...More thoughts
Re: Mutating Trigger...More thoughts [message #36483] Thu, 29 November 2001 07:37
Susan
Messages: 102
Registered: October 2001
Senior Member
Table B is a constraining table which means that the table might need to be read from for a referential integrity constraint. SQL statements in a trigger body may not read from or modify the primary, unique or foreign key columns of a constraining table. Usually, the solution is to create 2 triggers a row and a statement level. See Ask Tom link for more info.



----------------------------------------------------------------------
Previous Topic: Compare dates
Next Topic: Comparing two dates
Goto Forum:
  


Current Time: Fri Mar 29 09:12:26 CDT 2024