Stephen Carville schreef: > 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. > > For example, If I send the following: > > select a.statid, b.webstatdesc, a.pendid, c.penddesc, > a.certno, to_char(sysdate,'MM-DD-YYYY hh24:mi:ss') > from viewrequestmasall a, requeststatusparm b, pendingreasonparm c > where a.statid = b.statid > and a.pendid = c.pendid (+) > and tranid = 1 > and certno = ?' > > Then execute it with 29898535 for the bind variable,
Show us that part of your code, maybe it is just the binding that goes wrong? The "tranid" and "certno" in your "where" don't have table identifiers. If you assume that the result is one record, check for more. -- Affijn, Ruud "Gewoon is een tijger."
