cx-oracle-users

[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...

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
>

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

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

Thanks for the data point.

Yes, Python 2.5 final.

Unfortunately, it's HP/UX 11.23 on Itanium.  Oracle is 10.1.x on both
client and server.

Glad it's probably only a problem on this weird platform.  I have two
good workarounds (Python 2.4.3, or numbered bind values), so I'll wait
for a really rainy day before diving in and trying to fix it.

Thanks.

On 2006.10.11 07:41:17 -0600, Anthony Tuininga wrote:
> 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...