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