Database link and ORA-02041: client database did not begin a transaction
From: faris_idris_at_hotmail.com <(faris_idris_at_hotmail.com)>
Date: 17 Jul 2003 08:27:26 -0700
Message-ID: <fe478e3a.0307170727.69e2fb73_at_posting.google.com>
Hello, we are using Oracle 9i for client and server and Powerbuilder 8.0.3. We have a database link between two databases, whenever I try to do a simple select, update or insert I get the following error. Any idea why?
"ORA-02041: client database did not begin a transaction"
ORA-02041: client database did not begin a transaction
Received on Thu Jul 17 2003 - 17:27:26 CEST
Date: 17 Jul 2003 08:27:26 -0700
Message-ID: <fe478e3a.0307170727.69e2fb73_at_posting.google.com>
Hello, we are using Oracle 9i for client and server and Powerbuilder 8.0.3. We have a database link between two databases, whenever I try to do a simple select, update or insert I get the following error. Any idea why?
"ORA-02041: client database did not begin a transaction"
This is the sql I am using. It works fine if I am on sql plus. I have also tried to "using sqlca" as well as creating a new transaction for the select. All return the same error message.
string ls_new
select id_num
into :ls_new
from id_rec
where user_if = '818';
if sqlca.sqlcode <> 0 then
messagebox("Error ",sqlca.sqlerrtext)
end if
also this is the definition it gives for the error message
ORA-02041: client database did not begin a transaction
Cause: An update occurred at a coordinated database without the
coordinator beginning a distributed transaction. This may happen if a stored procedure commits and then performs updates, and the stored procedure is invoked remotely. It could also happen if an external transaction monitor violates the XA protocol.Action: If the cause is the former, check that any commit is not followed by an update.
Received on Thu Jul 17 2003 - 17:27:26 CEST