Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Session problem with triggers and remote DB Link
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 emailReceived on Fri Nov 16 2001 - 10:39:36 CST