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 <[EMAIL PROTECTED]>
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602
