Message-Id: <26007.339456@fatcity.com> From: "John Shaw" Date: Thu, 24 Jul 2003 10:49:36 -0500 Subject: Re: Update through a DBLink This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=_0A54187D.9CFD99F9 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable There is or at least was a problem if you had a autonomous transaction = across a dblink with a commit. >>> rlsmith@kmg.com 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 --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net=20 --=20 Author: Smith, Ron L. INET: rlsmith@kmg.com=20 Fat City Network Services -- 858-538-5051 http://www.fatcity.com=20 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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). --=_0A54187D.9CFD99F9 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML There is or at = least was a=20 problem if you had a autonomous transaction across a dblink with a=20 commit.

>>> rlsmith@kmg.com 7/24/2003 10:59:27 AM=20 >>>

One of or developers is work on a routine that will trigger a=20 procedure
that will use a dblink to update a table on another database.&= nbsp;=20 It seems
like I remember that something about a problem with procedures,= =20 dblinks,
updates? Does anyone remember anything about=20 that?

Thanks!
Ron
--
Please see the official ORACLE-L = FAQ: http://www.orafaq.net
--
Author: = Smith,=20 Ron L.
INET: rlsmith@kmg.com

Fat City Network=20 Services -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California -- Mailing list and = web=20 hosting=20 services
---------------------------------------------------------------= ------
To=20 REMOVE yourself from this mailing list, send an E-Mail message
to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the = message=20 BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing = list=20 you want to be removed from). You may
also send the HELP command = for=20 other information (like subscribing).