cx_Oracle, [[Python]] binding of [[Oracle]]

http://cx-oracle.sourceforge.net/

== 참고정보 ==


python setup.py build 후, 오류메세지가 나오면, 아래 명령을 수행한 뒤 다시 해본다. --from [[http://agiletesting.blogspot.com/2005/07/installing-python-241-and-cxoracle-on.html|AIX 에 cx_Oracle 설치하기]]

{{{
/usr/local/lib/python2.4/config/ld_so_aix cc_r -pthread -bI:/usr/local/lib/python2.4/config/python.exp build/temp.aix-5.2-2.4/cx_Oracle.o -L/oracle/product/9.2.0/lib32 -lclntsh -o build/lib.aix-5.2-2.4/cx_Oracle.so -s
}}}

각종 정보
 * [[http://www.orafaq.com/wiki/Python|사용에제]]
 * [[http://bbs.python.or.kr/viewtopic.php?t=25427|일반적인 사용법]]

다음처럼 contextmanager로 만들어두면 with절로 쓰기 편하다.

{{{#!python
from contextlib import contextmanager
import cx_Oracle

@contextmanager                                                                                
def oraconn():
    conn = cx_Oracle.connect('%s/%s' % (config.ORA_USER, config.ORA_PASSWD))
    cursor = conn.cursor()
    try:
        yield cursor
    except:
        conn.rollback()
        raise
    else:
        conn.commit()
    finally:
        conn.close()

with oraconn() as cursor:
    cursor.execute('...')
}}}

----
CategoryProgramLibrary