Are you *sure* the 3rd variant doesn't work? I'd expect that to work. '\r' should work just as well.
Which Oracle interface are you using? On 5/17/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > All, > > As the subject line says, I am having some trouble passing bind variables to > Oracle. When I pass a printable string value, such as 'NM', I get data. > When I try to pass a non-printable character, such as 'return' - chr(13), I > get no data back. I can't simply make NactionCode = chr(13), as python > would change the value of NactionCode to '\r' and Oracle sees this as a two > byte character, and not chr(13). I have looked into how Oracle might accept > something like '\x00' for chr(0), but to no avail. > > Any thoughts? > > thanks, > Michael > > def goGetIt( NactivityDt, NactionCode ): > > dataQuery = '''select a, b, c > from %s > where activityDt = :NactivityDt > and actionCode = :NactionCode > order by %s > ''' % ( schema.tableName ) > > dbm.cursor.execute(dataQuery, NactivityDt = activityDt, NactionCode = > actionCode ) > result = dbm.cursor.fetchall() > > return result > > NactivityDt = '12-apr-2005' > NactionCode = 'NM' > act1 = goGetIt( NactivityDt, NactionCode ) > > NactivityDt = '12-apr-2005' > NactionCode = 'chr(13)' > act2 = goGetIt( NactivityDt, NactionCode ) > > NactivityDt = '12-apr-2005' > NactionCode = chr(13) > act3 = goGetIt( NactivityDt, NactionCode ) -- --Guido van Rossum (home page: http://www.python.org/~guido/) _______________________________________________ DB-SIG maillist - [email protected] http://mail.python.org/mailman/listinfo/db-sig
