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
Jared Still wrote:
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
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,
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.
What happens when you use DBI *without* SQLRelay?
Philip
Dr.Ruud wrote:
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,
Garrett, Philip (MAN-Corporate) wrote:
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.
What happens when you use DBI
Stephen Carville schreef:
Dr.Ruud:
The tranid and certno in your where don't have table
identifiers. If you assume that the result is one record, check for
more.
I didn't know that dropping the table ids could make a difference.
I'll try adding them. Thanks.
They shouldn't make a
Dr.Ruud wrote:
Stephen Carville schreef:
Dr.Ruud:
I've been reviewing the sqltrace logs and I thinks this may be a case
where safe signals are biting me in the butt.
- prepare for DBD::SQLRelay::db (DBI::db=HASH(0x8e05078)~0x8de04f4
'select a.statid, b.webstatdesc, a.pendid,