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

[Anthony T. <ant...@gm...>]

I tried it in my own environment and it worked for me -- on a Fedora
Core 5 Linux box. Perhaps you could indicate a few more pieces of your
environment? Specifically the Oracle client version, Oracle server
version, operating system version. I'm assuming this is also with
Python 2.5 final, right?

On 10/10/06, David Ripton <dri...@ri...> wrote:
> 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...
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>