Re: HELP: Multiple triggers per table?
From: AWILSON <awilson_at_rci.rogers.com>
Date: 1996/12/05
Message-ID: <32A734AF.1B1C_at_rci.rogers.com>#1/1
then write a new trigger calling
both the above.
Date: 1996/12/05
Message-ID: <32A734AF.1B1C_at_rci.rogers.com>#1/1
Peter Beahan wrote:
>
> Hi, please help
>
> I am using Oracle 7.1 and need to be able to create multiple database
> triggers for the same table. We have purchased 2 different software
> packages (for the same database) that use triggers. It appears that we
> have to combine the 2 triggers ourselves to make it work.
>
> Is their anyway of doing this in Oracle 7.1?
> Do later versions of Oracle allow multiple triggers for table and SQL
> statement type (INSERT, UPDATE, DELETE)?
>
> regards Peter
You can't have multiple triggers for each database operation,
Convert the duplicate triggers to Stored Procedures eg for update
ON_UPDATE_SYSTEM_A
ON_UPDATE_SYSTEM_B
then write a new trigger calling
both the above.
The Wils. Received on Thu Dec 05 1996 - 00:00:00 CET