Re: Update through a DBLink
I can only say that with a rather basic type of update across a dblink we had a problem with it inserting two records, it was done with a trigger will all the code within the trigger, so this could be related, we made a work around to check for the record before trying to insert it Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = "If people did not sometimes do silly things, nothing intelligent would ever get done." - Ludwig Wittgenstein = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. "John Shaw" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 25-07-2003 02:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Update through a DBLink There is or at least was a problem if you had a autonomous transaction across a dblink with a commit. >>> [EMAIL PROTECTED] 7/24/2003 10:59:27 AM >>> One of or developers is work on a routine that will trigger a procedure that will use a dblink to update a table on another database. It seems like I remember that something about a problem with procedures, dblinks, updates? Does anyone remember anything about that? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Update through a DBLink
There is or at least was a problem if you had a autonomous transaction across a dblink with a commit.>>> [EMAIL PROTECTED] 7/24/2003 10:59:27 AM >>> One of or developers is work on a routine that will trigger a procedurethat will use a dblink to update a table on another database. It seemslike I remember that something about a problem with procedures, dblinks,updates? Does anyone remember anything about that?Thanks!Ron-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Smith, Ron L. INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Update through a DBLink
If the remote table uses object types, you will have trouble updating it from your local procedure. Richard -Original Message- Sent: Thursday, July 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L One of or developers is work on a routine that will trigger a procedure that will use a dblink to update a table on another database. It seems like I remember that something about a problem with procedures, dblinks, updates? Does anyone remember anything about that? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Update through a DBLink
Title: RE: Update through a DBLink No .. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: Update through a DBLink One of or developers is work on a routine that will trigger a procedure that will use a dblink to update a table on another database. It seems like I remember that something about a problem with procedures, dblinks, updates? Does anyone remember anything about that? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2