import cx_Oracle fails!
Daniel
danricofer at gmail.com
Thu May 19 19:58:37 EDT 2005
And, completing my answer, I'm sending you all how I finally got the
Python 2.4.1 and cx_Oracle-4.1 running on my HP-UX (sukz) box:
Box: HP-UX B.11.11
Compiling Python 2.4.1 with gcc 3.4.3
=====================================
./configure --with-libs='-lcl'
Added Makefile options:
CC= gcc -lc -lpthread
Changes on pyconfig.h:
Turn "#define _POSIX_THREADS" on
Compiling cx_Oracle-4.1:
=======================
Make sure to setup Oracle variables:
setenv ORACLE_HOME /oracle10/product/10.1.0
setenv ORACLE_BASE /oracle10
setenv TMPDIR /var/tmp
setenv PATH ${PATH}:$ORACLE_HOME/bin
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib32
setenv SHLIB_PATH $ORACLE_HOME/lib32
setenv TNS_ADMIN $ORACLE_HOME/network/admin
Changes on setup.py:
from: libPath = os.path.join(oracleHome, "lib")
to: libPath = os.path.join(oracleHome, "lib32")
And finally:
$ python
Python 2.4.1 (#20, May 18 2005, 20:33:21)
[GCC 3.4.3] on hp-ux11
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> dir(cx_Oracle)
['BINARY', 'BLOB', 'CLOB', 'CURSOR', 'Connection', 'Cursor',
'DATETIME', 'DataError', 'DatabaseError', 'Date', 'DateFromTicks',
'Error', 'FIXED_CHAR', 'FNCODE_BINDBYNAME', 'FNCODE_BINDBYPOS',
'FNCODE_DEFINEBYPOS', 'FNCODE_STMTEXECUTE', 'FNCODE_STMTFETCH',
'FNCODE_STMTPREPARE', 'IntegrityError', 'InterfaceError',
'InternalError', 'LOB', 'LONG_BINARY', 'LONG_STRING', 'NUMBER',
'NotSupportedError', 'OperationalError', 'ProgrammingError', 'ROWID',
'STRING', 'SYSDBA', 'SYSOPER', 'SessionPool', 'TIMESTAMP', 'Time',
'TimeFromTicks', 'Timestamp', 'TimestampFromTicks', 'UCBTYPE_ENTRY',
'UCBTYPE_EXIT', 'UCBTYPE_REPLACE', 'Warning', '__doc__', '__file__',
'__name__', 'apilevel', 'buildtime', 'connect', 'makedsn',
'paramstyle', 'threadsafety', 'version']
>>>
More information about the Python-list
mailing list