Home » SQL & PL/SQL » SQL & PL/SQL » Can DBLink can process the same record twice
Can DBLink can process the same record twice [message #308876] Tue, 25 March 2008 15:06 Go to next message
ambreen.fatima
Messages: 15
Registered: February 2007
Location: PAKISTAN
Junior Member
Can DBLink can process the same record twice (as erroneous behavior)?
Re: Can DBLink can process the same record twice [message #308877 is a reply to message #308876] Tue, 25 March 2008 15:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Post what you have. It is difficult to answer accurately and correctly if you don't post the whole question.

Regards
Michel
Re: Can DBLink can process the same record twice [message #308993 is a reply to message #308876] Wed, 26 March 2008 03:29 Go to previous message
Littlefoot
Messages: 21822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
DB link doesn't process anything; it is just a link. It is your code that does the processing.

So, if you are referring to a broken database link "in the middle of a transaction", changes won't take affect (i.e. it is all or nothing). So, if you did commit before the link broke, fine. If not, you'll have to repeat the transaction once again.

(I'm not talking about a bad example as a loop and "commit after every insert" scenario. It really is a bad idea.)
Previous Topic: Use Of Raise_appilcation_Error's error code like - 20001
Next Topic: Trigger
Goto Forum:
  


Current Time: Wed Nov 13 00:30:52 CST 2024