Re: [cx-oracle-users] import of cx_Oracle fails

[Anthony T. <an...@co...>]

I suspect you are using an older version of the Oracle 9i client, right?
Specifically, you are __NOT__ using Oracle 9.2, right? Older versions of
Oracle 9i do not have support for session pooling which is what the
error message is about. If you can't use Oracle 9.2, I would suggest
installing and using the Oracle 8i version of cx_Oracle instead or
rebuilding cx_Oracle.pyd yourself so that the offending procedure is not
linked. Let me know if this does not solve the problem for you. Thanks.

On Wed, 2003-10-08 at 08:40, Ralf Braun wrote:
> Hello,
> 
> i've installed the latest binary distributions (Python 2.3 and
> cx_Oracle-3.1-win32-9i-py23.exe) under W2k SP4.
> The cx_Oracle-installation was ok (as you can see in the
> cx_Oracle-wininst.log), the file "cx_Oracle.pyd" is on my Python path.
> 
> If I try to use the module, I'll get:
> 
> >>> import cx_Oracle
> 
> Traceback (most recent call last):
>   File "<pyshell#6>", line 1, in -toplevel-
>     import cx_Oracle
> ImportError: DLL load failed: The specified procedure could not be
> found.
> 
> 
> The "oci.dll" is on my search path.
> I'll get the connection with an external call:
>     os.execlp('sqlplus', 'sqlplus', 'system/system@bercsu1')
> 
> SQL*Plus: Release 9.0.1.3.0 - Production on Mi Okt 8 16:25:30 2003
> (c) Copyright 2001 Oracle Corporation.  All rights reserved.
> 
> Verbunden mit: (connected with:)
> Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.2.0 - Production
> SQL> ...
> 
> Are there any hints for diagnostics?
> 
> Regards Ralf
> 
> 
> 
> ______________________________________________________________________
> *** Installation started 2003/10/08 15:12 ***
> Source: C:\TEMP\Transfer\cx_Oracle-3.1-win32-9i-py23.exe
> 020 Reg DB Key: [Software\Microsoft\Windows\CurrentVersion\Uninstall]cx_Oracle-py2.3
> 040 Reg DB Value: [Software\Microsoft\Windows\CurrentVersion\Uninstall\cx_Oracle-py2.3]DisplayName=Python 2.3 cx_Oracle-3.1
> 040 Reg DB Value: [Software\Microsoft\Windows\CurrentVersion\Uninstall\cx_Oracle-py2.3]UninstallString="C:\Local\Programs\Python23\Removecx_Oracle.exe" -u "C:\Local\Programs\Python23\cx_Oracle-wininst.log"
> 100 Made Dir: C:\Local\Programs\Python23\cx_Oracle-doc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\HISTORY.txt
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\LICENSE.TXT
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\README.TXT
> 100 Made Dir: C:\Local\Programs\Python23\cx_Oracle-doc\html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\about.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\blank.gif
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\connobj.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\contents.gif
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\contents.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\cursorobj.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\cx_Oracle.css
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\cx_Oracle.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\dateobj.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\front.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\index.gif
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\index.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\lobobj.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\module.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\modules.gif
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\next.gif
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\node12.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\node4.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\node5.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\previous.gif
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\pyfav.gif
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\sesspool.html
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\up.gif
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\html\varobj.html
> 100 Made Dir: C:\Local\Programs\Python23\cx_Oracle-doc\test
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\Connection.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\Cursor.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\CursorVar.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\DateTimeVar.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\LobVar.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\LongVar.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\NumberVar.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\SessionPool.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\SetupTest.sql
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\SetupTest_9i.sql
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\StringVar.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\test.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\TestEnv.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\test_dbapi20.py
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\TimestampVar.py
> 200 File Copy: C:\Local\Programs\Python23\Lib\site-packages\cx_Oracle.pyd
> 100 Made Dir: C:\Local\Programs\Python23\Lib\site-packages\Release
> 200 File Copy: C:\Local\Programs\Python23\Lib\site-packages\Release\cx_Oracle.def
> 200 File Copy: C:\Local\Programs\Python23\Lib\site-packages\Release\cx_oracle.o
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\TimestampVar.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\test_dbapi20.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\TestEnv.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\test.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\StringVar.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\SessionPool.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\NumberVar.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\LongVar.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\LobVar.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\DateTimeVar.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\CursorVar.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\Cursor.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\Connection.pyc
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\TimestampVar.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\test_dbapi20.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\TestEnv.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\test.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\StringVar.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\SessionPool.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\NumberVar.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\LongVar.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\LobVar.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\DateTimeVar.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\CursorVar.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\Cursor.pyo
> 200 File Copy: C:\Local\Programs\Python23\cx_Oracle-doc\test\Connection.pyo
-- 
Anthony Tuininga
an...@co...
 
Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com