DCOracle syntax question

Jim St.Cyr jstcyr at mediaone.net
Sat Feb 16 00:56:06 EST 2002


I have a query of the form

select * from table where key = 'key' and date = (select max(to_char(date))
from table where key = 'key')

Through SQL*Plus this executes fine.  When executing through DCOracle I get
an empty result.  I've tried both tag = 'query' and cursor.execute(query).
I think that either the subquery or the inline quotes is throwing things off
but am at a loss.

Any pointers would be appreciated.

Thanks.

Jim





More information about the Python-list mailing list