Rows returned are out of sync with the request.

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.

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, I get:

'9' 'Pending' '3' 'Waiting for info from Client' '28757671' '08-22-2006 14:13:42'

Note that the certno's do not match.

If I make the next call with 29818691, I get:

'7' 'Completed' undef undef '29898535' '08-22-2006 14:13:43'

Not only do the certno's not match, the row returned in the second example matches the certno in the previous attempt.

I have a whole log full of this weirdness. Each execute seem to return the row from the previous one. It doesn't start that way but somewhere aong the way things are getting seriously out of whack.

Suggestaion are welcome. I know it could be in the connection pooling and I'll happily try something else if someone has a suggestion.

--
Stephen Carville <stephen@xxxxxxxxxxxxxx>
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602
.

Relevant Pages