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