cx_oracle

Lukas Ziegler fondue at webfondue.net
Sun Jun 24 16:04:58 EDT 2007


Hi,

I want to get an access to an oracle database.
For that I found the module cx_oracle
(http://www.python.net/crew/atuining/cx_Oracle/) and 
I have installed the version 'Windows Installer (Oracle 10g, Python 2.5)'.

Now I tried to run the script in the readme file:
-------------------------------------------------------------------
import cx_Oracle

# connect via SQL*Net string or by each segment in a separate argument
#connection = cx_Oracle.connect("user/password at TNS")
connection = cx_Oracle.connect("user", "password", "TNS")

cursor = connection.cursor()
cursor.arraysize = 50
cursor.execute("""
        select Col1, Col2, Col3
        from SomeTable
        where Col4 = :arg_1
          and Col5 between :arg_2 and :arg_3""",
        arg_1 = "VALUE",
        arg_2 = 5,
        arg_3 = 15)
for column_1, column_2, column_3 in cursor.fetchall():
    print "Values:", column_1, column_2, column_3
-------------------------------------------------------------------

And I got an error:
-------------------------------------------------------------------
Traceback (most recent call last):
  File "C:\Python25\cal_adjustment.py", line 1, in <module>
    import cx_Oracle
ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
-------------------------------------------------------------------


Do someone have an idea to solve the problem? A reinstall doesn't work.

Cheers
lukas






More information about the Python-list mailing list