Hi I am trying to create a TRIGGER function,that populates values to another table upon inserting a value into a table. The issue is,if there is a exception(in Table 2) everything gets rolled back including Table1.I dont want this to happen.i want the value of table1 to stay. I tried "try....except" and introduced SAVEPOINT.But resulted in runtime error.
Can anyone please help me out -- Deepak
