Re: [cx-oracle-users] Using cx_Oracle 6.0rc1 on Windows

[Anthony T. <ant...@gm...>]

Hi Walter,

DPI_DEBUG_LEVEL=7 causes a bunch of output that tells me which public
ODPI-C functions are being called. The fact that you are not getting any at
all suggests something is going wrong even before cx_Oracle code is
involved. Can you try a few more things?

1) Use python -v so you can see if the error is occurring prior to the
actual import of cx_Oracle (it may not help but it might, too)
2) Try without the use of venv and make sure that cx_Oracle.pyd is outside
of an "egg" -- in other words, as bare bones as possible; something in that
setup could be conflicting and if so, we can narrow down the problem a bit
bit further

I also note that you are using VS 2017. Another person noted that
uninstalling VS 2017 and using an earlier version worked for him -- why
that would be is an interesting question (!!?) but if you have a machine
that doesn't have VS 2017 but an earlier version that would be worth
testing, too.

Regarding the dbapi20 tests, it would appear that this is not well
supported by the community. Go ahead and log an issue. I'll do some more
investigation. Fixing the code you noted above to work with Python 3 is
easy enough -- but it won't help much if the dbapi20.py module isn't
available!

Anthony


On Mon, Jul 3, 2017 at 6:30 AM, Walter Dörwald <wa...@li...>
wrote:

> On 30 Jun 2017, at 13:55, Walter Dörwald wrote:
>
> On 29 Jun 2017, at 22:30, Anthony Tuininga wrote:
>>
>> Thanks, Chris. If anyone getting this issue is able to build cx_Oracle
>>> themselves, please do so with the environment variable DPI_DEBUG_LEVEL
>>> set
>>> to the value 7 and report the results here or in a GitHub issue. Thanks!
>>>
>>
>> [...]
>> As you suggested, we will try compiling cx_Oracle from source next week.
>>
>
> OK, we tried compiling cx_Oracle from source:
>
> ============================================================
> ===============
>
> C:\>cd C:\Program Files (x86)\Microsoft Visual
> Studio\2017\Community\VC\Auxiliary\Build
>
> C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Auxiliary\Build>vcvarsall.bat
> x86_amd64
> **********************************************************************
> ** Visual Studio 2017 Developer Command Prompt v15.0.26430.13
> ** Copyright (c) 2017 Microsoft Corporation
> **********************************************************************
> [ERROR:typescript.bat] TypeScript was not added to PATH since a valid
> installation was not found
> [ERROR:VsDevCmd.bat] *** VsDevCmd.bat encountered errors. Environment may
> be incomplete and/or incorrect. ***
>
> C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Auxil
> iary\Build>cd\
>
> C:\>cd \checkouts
>
> C:\checkouts>set
> [...]
> DPI_DEBUG_LEVEL=7
> [...]
> Path=C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools
> \MSVC\14.10.25017\bin\HostX86\x64;C:\Program Files (x86)\Microsoft Visual
> Studio\2017\Community\VC\Tools\MSVC\14.10.25017\bin\HostX86\x86;C:\Program
> Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\VC\VCPackages;C:\Program
> Files (x86)\Microsoft Visual Studio\2017\Community\Common7\
> IDE\CommonExtensions\Microsoft\TestWindow;C:\Program Files
> (x86)\Microsoft Visual Studio\2017\Community\Common7\
> IDE\CommonExtensions\Microsoft\TeamFoundation\Team Explorer;C:\Program
> Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\bin\Roslyn;C:\Program
> Files (x86)\Microsoft Visual Studio\2017\Community\Team Tools\Performance
> Tools;C:\Program Files (x86)\Microsoft Visual Studio\Shared\Common\VSPerfCollectionTools\;C:\Program
> Files (x86)\Windows Kits\10\bin\x86;C:\Program Files (x86)\Windows
> Kits\10\bin\10.0.15063.0\x86;C:\Program Files (x86)\Microsoft Visual
> Studio\2017\Community\\MSBuild\15.0\bin;C:\WINDOWS\Microsoft
> .NET\Framework\v4.0.30319;C:\Program Files (x86)\Microsoft Visual
> Studio\2017\Community\Common7\IDE\;C:\Program Files (x86)\Microsoft
> Visual Studio\2017\Community\Common7\Tools\;C:\pyvenvs\default\Scri
> pts;C:\oraclexe\app\oracle\product\11.2.0\server\bin;C:\
> Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\
> Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\NVIDIA
> Corporation\PhysX\Common;C:\Program Files\Intel\WiFi\bin\;C:\Program
> Files\Common Files\Intel\WirelessCommon\;C:\Program
> Files\Git\cmd;C:\Program Files\OpenVPN\bin;C:\WINDOWS\s
> ystem32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\
> System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows
> Kits\10\Windows Performance Toolkit\;C:\Users\uli\AppData\
> Local\Microsoft\WindowsApps;
> [...]
>
> C:\checkouts>\pyvenvs\default\scripts\activate
>
> (default) C:\checkouts>git clone https://github.com/oracle/pyth
> on-cx_Oracle
> Cloning into 'python-cx_Oracle'...
> remote: Counting objects: 3345, done.
> remote: Compressing objects: 100% (3/3), done.
> remote: Total 3345 (delta 0), reused 1 (delta 0), pack-reused 3342
> Receiving objects: 100% (3345/3345), 4.56 MiB | 567.00 KiB/s, done.
> Resolving deltas: 100% (2344/2344), done.
>
> (default) C:\checkouts>cd python-cx_Oracle
>
> (default) C:\checkouts\python-cx_Oracle>git clone
> https://github.com/oracle/odpi
> Cloning into 'odpi'...
> remote: Counting objects: 1875, done.
> remote: Compressing objects: 100% (172/172), done.
> remote: Total 1875 (delta 85), reused 59 (delta 25), pack-reused 1678
> Receiving objects: 100% (1875/1875), 979.74 KiB | 524.00 KiB/s, done.
> Resolving deltas: 100% (1363/1363), done.
>
> (default) C:\checkouts\python-cx_Oracle>python setup.py install
> running install
> running bdist_egg
> running egg_info
> writing cx_Oracle.egg-info\PKG-INFO
> writing dependency_links to cx_Oracle.egg-info\dependency_links.txt
> writing top-level names to cx_Oracle.egg-info\top_level.txt
> reading manifest file 'cx_Oracle.egg-info\SOURCES.txt'
> reading manifest template 'MANIFEST.in'
> writing manifest file 'cx_Oracle.egg-info\SOURCES.txt'
> installing library code to build\bdist.win-amd64\egg
> running install_lib
> running build_ext
> building 'cx_Oracle' extension
> C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools
> \MSVC\14.10.25017\bin\HostX86\x64\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG
> /MD -DDPI_DEBUG_LEVEL=7 -Iodpi/include -Iodpi/src
> -IC:\pyvenvs\default\include -Ic:\programme\python36\include
> -Ic:\programme\python36\include "-IC:\Program Files (x86)\Microsoft
> Visual Studio\2017\Community\VC\Tools\MSVC\14.10.25017\ATLMFC\include"
> "-IC:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.10.25017\include"
> "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\ucrt"
> "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\shared"
> "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\um"
> "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\winrt"
> /Tcsrc/cx_Oracle.c /Fobuild\temp.win-amd64-3.6\Release\src/cx_Oracle.obj
> -DBUILD_VERSION=6.0rc1
> cx_Oracle.c
> c:\checkouts\python-cx_oracle\src\Connection.c(851): warning C4311:
> "Typumwandlung": Zeigerverkürzung von "void *" zu "long"
> creating C:\checkouts\python-cx_Oracle\build\lib.win-amd64-3.6
> C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools
> \MSVC\14.10.25017\bin\HostX86\x64\link.exe /nologo /INCREMENTAL:NO /LTCG
> /DLL /MANIFEST:EMBED,ID=2 /MANIFESTUAC:NO /LIBPATH:C:\pyvenvs\default\libs
> /LIBPATH:c:\programme\python36\libs /LIBPATH:c:\programme\python36
> /LIBPATH:C:\pyvenvs\default\PCbuild\amd64 "/LIBPATH:C:\Program Files
> (x86)\Microsoft Visual Studio\2017\Community\VC\Tools
> \MSVC\14.10.25017\ATLMFC\lib\x64" "/LIBPATH:C:\Program Files
> (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.10.25017\lib\x64"
> "/LIBPATH:C:\Program Files (x86)\Windows Kits\10\lib\10.0.15063.0\ucrt\x64"
> "/LIBPATH:C:\Program Files (x86)\Windows Kits\10\lib\10.0.15063.0\um\x64"
> /EXPORT:PyInit_cx_Oracle build\temp.win-amd64-3.6\Release\src/cx_Oracle.obj
> /OUT:build\lib.win-amd64-3.6\cx_Oracle.cp36-win_amd64.pyd
> /IMPLIB:build\temp.win-amd64-3.6\Release\src\cx_Oracle.cp36-win_amd64.lib
> cx_Oracle.obj : warning LNK4197: Export "PyInit_cx_Oracle" wurde mehrmals
> angegeben; erste Angabe wird verwendet.
>    Bibliothek "build\temp.win-amd64-3.6\Release\src\cx_Oracle.cp36-win_amd64.lib"
> und Objekt "build\temp.win-amd64-3.6\Release\src\cx_Oracle.cp36-win_amd64.exp"
> werden erstellt.
> Code wird generiert.
> Codegenerierung ist abgeschlossen.
> creating build\bdist.win-amd64
> creating build\bdist.win-amd64\egg
> copying build\lib.win-amd64-3.6\cx_Oracle.cp36-win_amd64.pyd ->
> build\bdist.win-amd64\egg
> creating stub loader for cx_Oracle.cp36-win_amd64.pyd
> byte-compiling build\bdist.win-amd64\egg\cx_Oracle.py to
> cx_Oracle.cpython-36.pyc
> installing package data to build\bdist.win-amd64\egg
> running install_data
> creating build\bdist.win-amd64\egg\cx_Oracle-doc
> copying LICENSE.txt -> build\bdist.win-amd64\egg\cx_Oracle-doc
> copying README.txt -> build\bdist.win-amd64\egg\cx_Oracle-doc
> creating build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\AdvancedQueuing.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\AppContext.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\DatabaseChangeNotification.py ->
> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\DatabaseShutdown.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\DatabaseStartup.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\DMLReturningMultipleRows.py ->
> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\DRCP.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\Editioning.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\ImplicitResults.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\InsertGeometry.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\QueryChangeNotification.py ->
> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\ReturnLongs.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\ReturnNumbersAsDecimals.py ->
> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\ReturnUnicode.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\RowsAsInstance.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\ScrollableCursors.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\Threads.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\TransactionGuard.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\TypeHandlers.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\UniversalRowids.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> creating build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\BooleanVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\Connection.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\Cursor.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\CursorVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\DateTimeVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\DMLReturning.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\DropTest.sql -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\Error.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\Features12_1.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\IntervalVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\LobVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\LongVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\NCharVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\NumberVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\ObjectVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\SessionPool.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\SetupTest.sql -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\StringVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\test.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\TestEnv.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\test_dbapi20.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\TimestampVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uConnection.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uCursor.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uCursorVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uDateTimeVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uFeatures12_1.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uIntervalVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uLobVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uLongVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uNumberVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uObjectVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uSessionPool.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uStringVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uTimestampVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> creating build\bdist.win-amd64\egg\EGG-INFO
> copying cx_Oracle.egg-info\PKG-INFO -> build\bdist.win-amd64\egg\EGG-INFO
> copying cx_Oracle.egg-info\SOURCES.txt -> build\bdist.win-amd64\egg\EGG-
> INFO
> copying cx_Oracle.egg-info\dependency_links.txt ->
> build\bdist.win-amd64\egg\EGG-INFO
> copying cx_Oracle.egg-info\top_level.txt -> build\bdist.win-amd64\egg\EGG-
> INFO
> writing build\bdist.win-amd64\egg\EGG-INFO\native_libs.txt
> zip_safe flag not set; analyzing archive contents...
> __pycache__.cx_Oracle.cpython-36: module references __file__
> creating 'dist\cx_Oracle-6.0rc1-py3.6-win-amd64.egg' and adding
> 'build\bdist.win-amd64\egg' to it
> removing 'build\bdist.win-amd64\egg' (and everything under it)
> Processing cx_Oracle-6.0rc1-py3.6-win-amd64.egg
> removing 'c:\pyvenvs\default\lib\site-packages\cx_Oracle-6.0rc1-py3.6-win-amd64.egg'
> (and everything under it)
> creating c:\pyvenvs\default\lib\site-packages\cx_Oracle-6.0rc1-py3.6-
> win-amd64.egg
> Extracting cx_Oracle-6.0rc1-py3.6-win-amd64.egg to
> c:\pyvenvs\default\lib\site-packages
> Extracting cx_Oracle-6.0rc1-py3.6-win-amd64.egg to
> c:\pyvenvs\default\lib\site-packages
>   File "c:\pyvenvs\default\lib\site-packages\cx_Oracle-6.0rc1-py3.6
> -win-amd64.egg\cx_Oracle-doc\test\test_dbapi20.py", line 46
>     print "Testing cx_Oracle version", cx_Oracle.version
>                                     ^
> SyntaxError: Missing parentheses in call to 'print'
>
>   File "c:\pyvenvs\default\lib\site-packages\cx_Oracle-6.0rc1-py3.6
> -win-amd64.egg\cx_Oracle-doc\test\uFeatures12_1.py", line 42
>     [1L, 1L, 1L, 1L, 1L])
>       ^
> SyntaxError: invalid syntax
>
>   File "c:\pyvenvs\default\lib\site-packages\cx_Oracle-6.0rc1-py3.6
> -win-amd64.egg\cx_Oracle-doc\test\uNumberVar.py", line 26
>     nullableCol = 143L ** i
>                      ^
> SyntaxError: invalid syntax
>
> Adding cx-Oracle 6.0rc1 to easy-install.pth file
>
> Installed c:\pyvenvs\default\lib\site-packages\cx_oracle-6.0rc1-py3.6-
> win-amd64.egg
> Processing dependencies for cx-Oracle==6.0rc1
> Finished processing dependencies for cx-Oracle==6.0rc1
>
> ============================================================
> ===============
>
> It seems that this part of the code is not Python 3 compatible.
>
> Should I open a Github issue for those errors?
>
> After fixing those errors "python setup.py install" runs to completion,
> however importing cx_Oracle still fails with the same error message:
>
> ============================================================
> ===============
>
> (default) C:\checkouts\python-cx_Oracle>python setup.py install
> running install
> running bdist_egg
> running egg_info
> writing cx_Oracle.egg-info\PKG-INFO
> writing dependency_links to cx_Oracle.egg-info\dependency_links.txt
> writing top-level names to cx_Oracle.egg-info\top_level.txt
> reading manifest file 'cx_Oracle.egg-info\SOURCES.txt'
> reading manifest template 'MANIFEST.in'
> writing manifest file 'cx_Oracle.egg-info\SOURCES.txt'
> installing library code to build\bdist.win-amd64\egg
> running install_lib
> running build_ext
> building 'cx_Oracle' extension
> C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools
> \MSVC\14.10.25017\bin\HostX86\x64\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG
> /MD -DDPI_DEBUG_LEVEL=7 -Iodpi/include -Iodpi/src
> -IC:\pyvenvs\default\include -Ic:\programme\python36\include
> -Ic:\programme\python36\include "-IC:\Program Files (x86)\Microsoft
> Visual Studio\2017\Community\VC\Tools\MSVC\14.10.25017\ATLMFC\include"
> "-IC:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.10.25017\include"
> "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\ucrt"
> "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\shared"
> "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\um"
> "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\winrt"
> /Tcsrc/cx_Oracle.c /Fobuild\temp.win-amd64-3.6\Release\src/cx_Oracle.obj
> -DBUILD_VERSION=6.0rc1
> cx_Oracle.c
> c:\checkouts\python-cx_oracle\src\Connection.c(851): warning C4311:
> "Typumwandlung": Zeigerverkürzung von "void *" zu "long"
> creating C:\checkouts\python-cx_Oracle\build\lib.win-amd64-3.6
> C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools
> \MSVC\14.10.25017\bin\HostX86\x64\link.exe /nologo /INCREMENTAL:NO /LTCG
> /DLL /MANIFEST:EMBED,ID=2 /MANIFESTUAC:NO /LIBPATH:C:\pyvenvs\default\libs
> /LIBPATH:c:\programme\python36\libs /LIBPATH:c:\programme\python36
> /LIBPATH:C:\pyvenvs\default\PCbuild\amd64 "/LIBPATH:C:\Program Files
> (x86)\Microsoft Visual Studio\2017\Community\VC\Tools
> \MSVC\14.10.25017\ATLMFC\lib\x64" "/LIBPATH:C:\Program Files
> (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.10.25017\lib\x64"
> "/LIBPATH:C:\Program Files (x86)\Windows Kits\10\lib\10.0.15063.0\ucrt\x64"
> "/LIBPATH:C:\Program Files (x86)\Windows Kits\10\lib\10.0.15063.0\um\x64"
> /EXPORT:PyInit_cx_Oracle build\temp.win-amd64-3.6\Release\src/cx_Oracle.obj
> /OUT:build\lib.win-amd64-3.6\cx_Oracle.cp36-win_amd64.pyd
> /IMPLIB:build\temp.win-amd64-3.6\Release\src\cx_Oracle.cp36-win_amd64.lib
> cx_Oracle.obj : warning LNK4197: Export "PyInit_cx_Oracle" wurde mehrmals
> angegeben; erste Angabe wird verwendet.
>    Bibliothek "build\temp.win-amd64-3.6\Release\src\cx_Oracle.cp36-win_amd64.lib"
> und Objekt "build\temp.win-amd64-3.6\Release\src\cx_Oracle.cp36-win_amd64.exp"
> werden erstellt.
> Code wird generiert.
> Codegenerierung ist abgeschlossen.
> creating build\bdist.win-amd64
> creating build\bdist.win-amd64\egg
> copying build\lib.win-amd64-3.6\cx_Oracle.cp36-win_amd64.pyd ->
> build\bdist.win-amd64\egg
> creating stub loader for cx_Oracle.cp36-win_amd64.pyd
> byte-compiling build\bdist.win-amd64\egg\cx_Oracle.py to
> cx_Oracle.cpython-36.pyc
> installing package data to build\bdist.win-amd64\egg
> running install_data
> creating build\bdist.win-amd64\egg\cx_Oracle-doc
> copying LICENSE.txt -> build\bdist.win-amd64\egg\cx_Oracle-doc
> copying README.txt -> build\bdist.win-amd64\egg\cx_Oracle-doc
> creating build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\AdvancedQueuing.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\AppContext.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\DatabaseChangeNotification.py ->
> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\DatabaseShutdown.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\DatabaseStartup.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\DMLReturningMultipleRows.py ->
> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\DRCP.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\Editioning.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\ImplicitResults.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\InsertGeometry.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\QueryChangeNotification.py ->
> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\ReturnLongs.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\ReturnNumbersAsDecimals.py ->
> build\bdist.win-amd64\egg\cx_Oracle-doc\samples
> copying samples\ReturnUnicode.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\RowsAsInstance.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\ScrollableCursors.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\Threads.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\TransactionGuard.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\TypeHandlers.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> copying samples\UniversalRowids.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\samples
> creating build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\BooleanVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\Connection.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\Cursor.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\CursorVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\DateTimeVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\DMLReturning.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\DropTest.sql -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\Error.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\Features12_1.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\IntervalVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\LobVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\LongVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\NCharVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\NumberVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\ObjectVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\SessionPool.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\SetupTest.sql -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\StringVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\test.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\TestEnv.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\test_dbapi20.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\TimestampVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uConnection.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uCursor.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uCursorVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uDateTimeVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uFeatures12_1.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uIntervalVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uLobVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uLongVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uNumberVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uObjectVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uSessionPool.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> copying test\uStringVar.py -> build\bdist.win-amd64\egg\cx_Oracle-doc\test
> copying test\uTimestampVar.py -> build\bdist.win-amd64\egg\cx_O
> racle-doc\test
> creating build\bdist.win-amd64\egg\EGG-INFO
> copying cx_Oracle.egg-info\PKG-INFO -> build\bdist.win-amd64\egg\EGG-INFO
> copying cx_Oracle.egg-info\SOURCES.txt -> build\bdist.win-amd64\egg\EGG-
> INFO
> copying cx_Oracle.egg-info\dependency_links.txt ->
> build\bdist.win-amd64\egg\EGG-INFO
> copying cx_Oracle.egg-info\top_level.txt -> build\bdist.win-amd64\egg\EGG-
> INFO
> writing build\bdist.win-amd64\egg\EGG-INFO\native_libs.txt
> zip_safe flag not set; analyzing archive contents...
> __pycache__.cx_Oracle.cpython-36: module references __file__
> creating 'dist\cx_Oracle-6.0rc1-py3.6-win-amd64.egg' and adding
> 'build\bdist.win-amd64\egg' to it
> removing 'build\bdist.win-amd64\egg' (and everything under it)
> Processing cx_Oracle-6.0rc1-py3.6-win-amd64.egg
> removing 'c:\pyvenvs\default\lib\site-packages\cx_Oracle-6.0rc1-py3.6-win-amd64.egg'
> (and everything under it)
> creating c:\pyvenvs\default\lib\site-packages\cx_Oracle-6.0rc1-py3.6-
> win-amd64.egg
> Extracting cx_Oracle-6.0rc1-py3.6-win-amd64.egg to
> c:\pyvenvs\default\lib\site-packages
> cx-Oracle 6.0rc1 is already the active version in easy-install.pth
>
> Installed c:\pyvenvs\default\lib\site-packages\cx_oracle-6.0rc1-py3.6-
> win-amd64.egg
> Processing dependencies for cx-Oracle==6.0rc1
> Finished processing dependencies for cx-Oracle==6.0rc1
>
> (default) C:\checkouts\python-cx_Oracle>python
> Python 3.6.0 (v3.6.0:41df79263a11, Dec 23 2016, 08:06:12) [MSC v.1900 64
> bit (AMD64)] on win32
> Type "help", "copyright", "credits" or "license" for more information.
>
>> import cx_Oracle
>>>>
>>> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
> UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe4 in position 66:
> invalid continuation byte
>
>>
>>>>
> ============================================================
> ===============
>
> BTW, what does the DPI_DEBUG_LEVEL environment variable do? It seem the
> above code doesn't produce any additional output.
>
> Servus,
>    Walter
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>