Search code examples
pythonoraclepython-3.3

Python 3.3 - Connect with Oracle database


Is there a module for python 3.3 to connect with Oracle Databases? Which is the easiest to use? Something like the mysql module, only works with Oracle.

Preferably version 10g, but 11g will do just fine.


Solution

  • There is: cx_Oracle

    # Install --> You should have oracle installed otherwise exception will be raised
    
    pip install cx_Oracle
    
    import cx_Oracle
    
    con = cx_Oracle.connect('pythonhol/[email protected]/orcl')
    print con.version
    
    con.close()
    

    http://www.orafaq.com/wiki/Python

    http://www.oracle.com/technetwork/articles/dsl/python-091105.html