Re: Rows returned are out of sync with the request.
- From: stephen@xxxxxxxxxxxxxx (Stephen Carville)
- Date: Fri, 25 Aug 2006 07:37:10 -0700
Jared Still wrote:
On Tue, 2006-08-22 at 16:11 -0700, Stephen Carville wrote:
I'm not quite sure how to describe this problem.
When I make a call to an Oracle 10g database using DBI and SQLRelay (for connection pooling) I seem to get results from the previous SELECT.
Is the Oracle version 10.2?
Yes. 10.2.0.2
Are multiple schema's with the same table names involved?
I don't know but I'm going to find out.
Are unqualified tablenames used? ( no schema name - 'select * from my table'
not 'select * from scott.my_table')
Yes
If all of the above are true, then you should probably
contact Oracle Support. There's a bug that causes
some concurrency issues under those circumstances.
(Sorry, don't have the bug #)
Thanks for the pointer.
Jared
--
Stephen Carville <stephen@xxxxxxxxxxxxxx>
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602
.
- References:
- Rows returned are out of sync with the request.
- From: Stephen Carville
- Re: Rows returned are out of sync with the request.
- From: Jared Still
- Rows returned are out of sync with the request.
- Prev by Date: Re: Remote DB2 connectivity in Perl
- Next by Date: RE: Remote DB2 connectivity in Perl
- Previous by thread: Re: Rows returned are out of sync with the request.
- Next by thread: RE: Rows returned are out of sync with the request.
- Index(es):
Relevant Pages
|
