Originally posted by: PSAK

Can we use multiple WHEN condition in a single Oracle trigger command ?

I want to trigger based on row insert into a table say 'TableX' and it should be based on values in two different columns. WHEN condition works when its based on a single column value, but when i tried to use AND condition, its not working.

-TR R I TableX W [TableX.Col1] = 'Condition 1' ---> this works.

But my requirement is to check values in two different columns after the trigger and I tried as below, but not working.

-TR R I TableX W [TableX.Col1] = 'Condition 1'  & [TableX.Col2] = 'Condition 2'

How can we do that ?

Originally posted by: paul.brett

I don't believe multiple WHEN conditions are supported, but to be sure, please raise an Electronic Service Request (SR) at : https://www-947.ibm.com/support/servicerequest/Home.action

The documentation does not seem particularly clear on this subject (to me).

Thank-you

Paul

Follow me on Twitter

Originally posted by: PSAK

multiple WHEN condition works with AND operator and not with '&'.