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