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
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: Thu May 23 00:11:19 CDT 2024