Re: Oracle Data Access in Python

A.M wrote:

Hi,



I am familiar with Perl's DBI programming.



In Python, do we access to Oracle by using DBI?

No.

Is Oracle DBD driver included with Python distributions?

No.

What is the most common strategy for accessing to Oracle data through
Python?

cx_Oracle seems to be the leading module for Oracle access today. It works well.

http://www.cxtools.net/default.aspx?nav=cxorlb


You'll need the apropriate Oracle client installed for it to work, of course. Oracle's "Instant Client" is probably the easiest way to get what you need for that.


Hope that helps,

Bill
.

Relevant Pages

  • Re: Oracle Data Access in Python
    ... >> I am familiar with Perl's DBI programming. ... >> Is Oracle DBD driver included with Python distributions? ... development of DCOracle has lagged of late. ...
    (comp.lang.python)
  • Oracle Data Access in Python
    ... I am familiar with Perl's DBI programming. ... In Python, do we access to Oracle by using DBI? ... included with Python distributions? ...
    (comp.lang.python)
  • cx_OracleTools 7.4
    ... cx_OracleTools is a set of Python scripts that handle Oracle database ... In ExportObjects, create the directory before any exporting ... Eliminated identical grants made by different users when describing objects. ...
    (comp.lang.python.announce)
  • cx_Oracle 4.3.2
    ... conforms to the Python database API 2.0 specifications with a few ... Fixed support for native doubles and floats in Oracle 10g; ... Added support for autocommit mode as requested by Ian Kelly. ...
    (comp.lang.python.announce)
  • Re: setting v$session.program?
    ... Why on earth? ... They are python programs, ... oracle shows "python.exe" for all programs. ... For security reasons it is practically useless as well, because you can easily change this attribute by simply renaming of executables - works on windows and unix. ...
    (comp.databases.oracle.misc)