Re: Update through a DBLink

From: John Shaw <John.Shaw_at_correctionscorp.com>
Date: Thu, 24 Jul 2003 10:49:36 -0500
Message-Id: <26007.339456@fatcity.com>

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_at_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_at_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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"=
>
<META content=3D"MSHTML 5.50.4926.2500" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">There is or at =
least was a=20
problem if you had a autonomous transaction across a dblink with a=20 commit. >>> rlsmith_at_kmg.com 7/24/2003 10:59:27 AM=20 >>> 
<DIV>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: <A=20
href=3D"http://www.orafaq.net">http://www.orafaq.net</A> -- Author: = Smith,=20
Ron L.   INET: rlsmith_at_kmg.com Fat City Network=20 Services    -- 858-538-5051 <A=20 href=3D"http://www.fatcity.com">http://www.fatcity.com</A> San = Diego,=20
California        -- Mailing list and = web=20
hosting=20

services<BR>---------------------------------------------------------------=

------ To=20
REMOVE yourself from this mailing list, send an E-Mail message to:=20 ListGuru_at_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). </DIV></BODY></HTML> Received on Thu Jul 24 2003 - 10:49:36 CDT