Executing -
update arschema set nextid = 200 where schemaid='3321';
did not help.
The same error occures -
INSERT INTO T3321 (C536870913,C1) VALUES ('test',200)
*** ERROR *** ORA-02047: cannot join the distributed transaction in progress
While now I can execute successfully this coomand
INSERT INTO T3321 (C536870913,C1) VALUES ('test',200)
using SQLPlus.
Our environment is -
Solaris 9 + Oracle 9.2
Kind Regards / C уважением
Dmitry Bezhenar
________________________________
From: Bezhenar, Dmitry
Sent: Monday, March 12, 2007 12:28 PM
To: '[email protected]'
Subject: Inserting into view form - request ID issue
Hello List,
I experience some problems with inserting rows into our view forms.
The SQL log shows
INSERT INTO T3321 (C536870913,C1) VALUES ('test',1)
*** ERROR *** ORA-02047: cannot join the distributed transaction in progress
C1 field is a key (request ID), it should be incremental.
I have 50 records already in that table and C1 cannot equal 1.
Is it possible to assign Request ID for view forms manually?
Maybe I should recreate this view form and make Request ID field another way?
Thank you.
Kind regards / С уважением
Dmitry Bezhenar
SIEMENS
OOO Siemens Business Services
Kozhevnicheskij Per. 6
Moscow / Russia
Tel. +7 495 737 2697
Mob. +7 916 615 7978
Email [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
