Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Session problem with triggers and remote DB Link

Re: Session problem with triggers and remote DB Link

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 16 Nov 2001 16:39:36 GMT
Message-ID: <3bf54135.1450109927@news.globix.com>


I meant do you close your xaction on the local db, not within the trigger.

On 16 Nov 2001 02:48:45 -0800, fmas_at_hubwoo.com (fredericm) wrote:

>Hi, thanks for your answer but I think commit is implicit because of
>the begin and end trigger, overall we tried to explicitly commit we
>get a 2067 ora error on all the other query ??
>
>Any idea ?
>
>regards
>Fred

.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email
Received on Fri Nov 16 2001 - 10:39:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US