by any chance you dont have a thick client like powerbuilder or microsoft ADO access involved int eh transaction ?
i've seen this error on access from a thick client becuase of microsoft transaction server auto commit internally.
----- Original Message ----
From: Paula Stankus <paulastankus@yahoo.com>
To: oracle-l@freelists.org
Sent: Saturday, June 24, 2006 2:25:41 AM
Subject: Re: ORA-02041
Guys,
We are running on Oracle 8.1.7 and we have database links to another 8.1.7. Finally when we query objects over the database links within a stored procedure (that has no rollbacks/commits but only had selects and a cursur) we get
ORA-02041.
It looks like it might be a bug. Has anyone dealt with this one before?
Thanks,
Paula
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
