I've a procedure which inserts,updates rows in a table(on db1) which is in another DB(say db2,using database link). If my insert or update fails for any reason I'm getting the above error . I've a exception when others then rollback; statement inside the procedure. But still I'm getting the above error. Can anyone help me to find out why I'm getting this error ?
And after the rollback statement in exception block I want to call a procedure(on db2) ,to insert a row into a log table (just keep track of the records failed). Is there any way to do this ?