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? Are multiple schema's with the same table names involved? Are unqualified tablenames used? ( no schema name - 'select * from my table' not 'select * from scott.my_table') 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 #) Jared
