Thanks for the reply.

But my problem is that, I cannot modify the Trigger neither can i disable it as this trigger is written in a CMS tool which i m using.

Is there any way of achieving the same functionality by writting any DB query/ procedure etc.

Hemant...

The Trigger is giving following exception

java.sql.SQLExc eption: ORA-04091: table PSCONTENT.VGNAS CHANNEL is mutating, trigger/function may not see it ORA-06512: at "PSCONTENT.CHEC K_CHANNEL_UNPUB LISH", line 4 ORA-06512: at "PSCONTENT.CHEC K_CHANNEL_UNPUB LISH_TR", line 1 ORA-04088: error during execution of trigger ............... ............... ..

// Trigger
CREATE OR REPLACE TRIGGER check_channel_u npublish_tr...