Now i have the following trigger which will select the service field from the netservice table with respect to :new.balance.
create or replace trigger test_trigger before update on netservice
for each row
select service into servc from netservice where balance=:new.balance;
if servc='P2' then
raise_application_error(-20000,'Got the desired values');
Before updating i have inserted a value using the following query
insert into netservice values('01819421877','P2',1000);
But its giving me a table is mutating error...
can anyone tell me how to solve it??...