[cx-oracle-users] A probably stupid question...

[Kim <kim...@ya...>]

whatstr="SELECT field111 from MSG_ARCHIVE where "+searchField+" =:record_number
and field4 between :s_time and :e_time"
curs.prepare(whatstr)
curs.execute(None, {'record_number':mrn,'s_time':start_time, 'e_time':end_time})

searchField is actually field111, mrn is a set number (9 digits), 
the start_time and end_time are oracle timestamps.

This simply hangs -- no error, no return. If I hit ctrl-c, it simply says
keyboard interrupt (no kidding...).

I am having difficulties with a python script, that was working with our 10g
database and 11g client, but now does not work...

whatstr=('select '+out_fields+' from MSG_ARCHIVE where '+searchField+' =
:record_number and field4 between :s_time and :e_time')
print whatstr
curs.execute(whatstr,{'record_number':mrn, 's_time':start_time, 
'e_time':end_time})

Can anyone think of why this would have changed? I can run either a
record_number search or a "between timestamp" search and have it work fine.

Thank you very much for your time!