-
Hi,
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 ?
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|