cx_Oracle question

Richard Schulman raschulmanxx at verizon.net
Fri Sep 8 16:02:29 EDT 2006


Richard Schulman:
>> cursor.execute("""select mean_eng_txt from mean
>>                   where mean_id=:arg_1""",arg_1)

Uwe Hoffman:
>cursor.execute("""select mean_eng_txt from mean
>                    where mean_id=:arg_1""",{"arg_1":arg_1})

R.S.'s error message:
>> Traceback (most recent call last):
>>    File "oracle_test.py", line 7, in ?
>>       cursor.execute('select mean_eng_txt from mean where
>>       mean_id=:arg_1',arg_1)
>> TypeError: expecting a dictionary, sequence or keyword args

Excellent! Vielen Dank, Uwe (and Diez).

This also turned out to work:

cursor.execute("""select mean_eng_txt from mean
                  where mean_id=:arg_1""",arg_1=arg_1)

Richard Schulman
For email reply, remove the xx part



More information about the Python-list mailing list