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("Err or ",sqlca.sqlerrt ext)
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.
---------------------------------------- 1 14479
after doing seach on other groups (MS Access) found a solution for my
problem..
Control Panal-->SYSTEM DSN--> pes_orcle_odbc-->Configure-->
Workarounds-->Disable Microsoft Transaction Server (check it)
worked wonders fa*********@hot mail.com (fa*********@ho tmail.com) wrote in message news:<fe******* *************** ****@posting.go ogle.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("Err or ",sqlca.sqlerrt ext) 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. ---------------------------------------- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Thiemo Kellner |
last post by:
Hi,
we have come across the problem that the execution of a stored
procedure by our scheduling tool (cronacle -> over db link) fails with
the error message:
ORA-04068: existing state of packages has been discarded
ORA-04062: of has been changed
ORA-04062: timestamp of procedure "LARA.PRC_BERECHNE_ZINSFAKTOR" has
been changed
ORA-06512: at "LARA.LARA_PRC_BERECHNE_ZINSFAKTOR", line 15
|
by: Doron |
last post by:
I'm getting a ORA-00600 error on SYS.EXU8REF (see trace file
below).
SYS.EXU8REF is a view so the problem should be with one of the
underlaying tables. i didnt run oerr12700 yet. can i find the
object/block that is giving the error via the RDBA? if so then how?
any suggestions appreciated!
|
by: bdj |
last post by:
Hello!
I have at set of tnsnames.ora. I wich to make an union, e.g. a single file
of it.
How can I do that easy?
Greetings
Bjørn
|
by: Michael John |
last post by:
Hey,
how can I get ORA-..... error messages in languages other than
english.
I did a
alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1';
but this only threw an ORA-00922.
Or I'm wrong and NLS_LANGUAGE and NLS_TERRITORY doesn't have an effect
on the text of ORA- error messages at all?
|
by: Jawahar |
last post by:
All,
I have a C# application with an Oracle backend. There is a fair amount of
locking being used to prevent two users from update the same records. So we
use the Oracle FOR UPDATE NOWAIT in our SQL calls. This works fine and the
second user is not allowed to access the same record as the first user.
Currently we are using a try catch block to catch the Oracle exception
ORA-0054. Then we exit the subroutine.
I am trying to look for a...
| |
by: mpatel6 |
last post by:
I had this error in alert log and my instance was down, anybody can help me?
Errors in file /u01/app/oracle/admin/sotstest/bdump/sotstest_p004_626740.trc:
ORA-07445: exception encountered: core dump
Wed Sep 20 12:31:12 2006
Errors in file /u01/app/oracle/admin/sotstest/bdump/sotstest_pmon_643152.trc:
ORA-00600: internal error code, arguments: , , , , , , ,
ORA-27302: failure occurred at: skgslfr
Wed Sep 20 12:31:22 2006
Errors...
|
by: CJM |
last post by:
I have a working web application (ASP) which links to an Oracle 10g DB via
OO4O. I'm trying to port it to either of two test servers, but in fact, I
can't get it to work with either - 'Unable to make connection, ORA-12154:
TNS:could not resolve the connect identifier specified'. This error occurs
in the applications global.asa file where I'm trying to set up a connection
pool:
<object runat="Server" scope="Application" id="oSession"...
|
by: prashanttarudkar9 |
last post by:
Hi all,
I installed oracle server 9.2.0.4.0 in Windows 2000 professional O.S.
But now I am trying to connect with server, but I got the following error.
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor .
Even I checked sqlnet.ora, tnsnames.ora and listner.ora file, it all are proper.
Kindly, guide me for it. It is very needful to me.
|
by: Nitvar |
last post by:
When i am trying to connect to oracle it is giving me these two errors
ORA-12224: TNS:no listener
ORA-01034: ORACLE not available
I am new to oracle ,plz help
I am using solaris 5.6 and oracle 8.0.5 version
I am posting my listener.ora and Tnsname
|
by: hoonig |
last post by:
I have this traditional error "ORA-12560:TNS:Protocol Adapter Error"
when trying to connect to my Oracle 8i databases on Netware (i.e when
i load svrmgr31, plus81, etc...)
Listener seems to work properly (instances are present).
I would like to check up Oracle environment on Netware but how? If
errors, how can i set on this environment?
Does svrmgr31 automaticly find %oracle_home%/nlm/config.ora, where all
oracle environment is...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |