[cx-oracle-users] Problem with Python 2.5 and named bind values?

[David R. <dri...@ri...>]

Here's a small script to test named bind values.

# CODE   testbind.py
"""Run me like this: python testbind.py user passwd dsn"
import sys
import cx_Oracle
user, passwd, dsn = sys.argv[1:4]
conn = cx_Oracle.Connection(user, passwd, dsn)
cursor = conn.cursor()
sql = "select owner from all_tables where table_name = :table_name"
kwparams = {"table_name": "DUAL"}
columns = cursor.execute(sql, kwparams)
row = cursor.fetchone()
print row[0]
# END CODE

With cx_Oracle 4.2 and Python 2.4.3, the test works fine.

With cx_Oracle 4.2 and Python 2.5, I get an exception
"cx_Oracle.DatabaseError: ORA-01008: not all variables bound"
on the cursor.execute line.

Can others reproduce this, or is the problem a quirk of my local
environment?

Thanks.

-- 
David Ripton    dri...@ri...