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: 65146
Registered: March 2007
Location: Nanterre, France, http://...
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: 21148
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: Regarding Nulls in Indexes
Next Topic: Where can I find any html parser that I can use in PL/SQL?
Goto Forum:
  


Current Time: Mon Aug 21 07:16:31 CDT 2017

Total time taken to generate the page: 0.12181 seconds