Re: Rows returned are out of sync with the request.



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


.



Relevant Pages

  • Warning: Do not use DISM on Solaris 8 or Solaris 9 pre-update 2
    ... The infodoc goes on to recommend that DISM not ... be used at all with Solaris 8, or Solaris 9 prior to update 2. ... this bug since it can be such a silent performance killer. ... If you see ora_dism_then Oracle 9i is making use of DISM ...
    (SunManagers)
  • Re: BUG or FEATURE
    ... 10x two all for replay. ... work better/easier will be a feature and not bug. ... goes to oracle. ...
    (comp.software.testing)
  • Re: BUG or FEATURE
    ... It helps when you have a definition of "bug". ... feature were you can select and delete all of them. ... The problem that we run into is the oracle problem. ... which ones (does management think) are the most ...
    (comp.software.testing)
  • Re: [Full-disclosure] Which is more secure? Oracle vs. Microsoft
    ... AK>> The following bugs are Oracle application server bugs (Oracle Portal ... DL> app these are PL/SQL packages in the database server. ... is an Oracle database bug? ...
    (Full-Disclosure)
  • Re: BUG or FEATURE
    ... needs to prove that "See this seems to be a bug to me - I am typical ... and no where it is mentioned that the feature should work like this". ... lack of knowledge that "there is no Oracle". ... which ones (does management think) are the most ...
    (comp.software.testing)