Re: cx_Oracle 6.2

"Walter Dörwald" <[email protected]> Wed, 07 Mar 2018 17:14:53 +0100
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <[email protected]>
--===============5115569449831942593==
Content-Type: multipart/alternative;
 boundary="=_MailMate_B1B9373F-09BB-4A82-8768-1EC5C47A317D_="


--=_MailMate_B1B9373F-09BB-4A82-8768-1EC5C47A317D_=
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable

On 6 Mar 2018, at 18:19, Anthony Tuininga wrote:

> Hi Walter,
>
> This error is due to the fact that cxoModule.h is a file with a new
> extension so it wasn't covered by MANIFEST.in.
> I have corrected that and
> also uploaded a revised source package so this should be corrected =

> now.
> Apologies for the inconvenience!

Thanks! Now the installation worked on my Mac.

However on a (german) Windows 10, we get the following error:

```
C:\Users\hannes>pip install cx_Oracle
Collecting cx_Oracle
   Downloading cx_Oracle-6.2-2.tar.gz (240kB)
     100% =

|=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=
=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=
=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=
=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88| =

245kB 1.6MB/s
Installing collected packages: cx-Oracle
   Running setup.py install for cx-Oracle ... error
Exception:
Traceback (most recent call last):
   File =

"c:\users\hannes\appdata\local\programs\python\python36\lib\site-packages=
\pip\compat\__init__.py", =

line 73, in console_to_str
     return s.decode(sys.__stdout__.encoding)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0x94 in position 93: =

invalid start byte

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
   File =

"c:\users\hannes\appdata\local\programs\python\python36\lib\site-packages=
\pip\basecommand.py", =

line 215, in main
     status =3D self.run(options, args)
   File =

"c:\users\hannes\appdata\local\programs\python\python36\lib\site-packages=
\pip\commands\install.py", =

line 342, in run
     prefix=3Doptions.prefix_path,
   File =

"c:\users\hannes\appdata\local\programs\python\python36\lib\site-packages=
\pip\req\req_set.py", =

line 784, in install
     **kwargs
   File =

"c:\users\hannes\appdata\local\programs\python\python36\lib\site-packages=
\pip\req\req_install.py", =

line 878, in install
     spinner=3Dspinner,
   File =

"c:\users\hannes\appdata\local\programs\python\python36\lib\site-packages=
\pip\utils\__init__.py", =

line 676, in call_subprocess
     line =3D console_to_str(proc.stdout.readline())
   File =

"c:\users\hannes\appdata\local\programs\python\python36\lib\site-packages=
\pip\compat\__init__.py", =

line 75, in console_to_str
     return s.decode('utf_8')
UnicodeDecodeError: 'utf-8' codec can't decode byte 0x94 in position 93: =

invalid start byte
```

> Anthony
>
> On Tue, Mar 6, 2018 at 4:02 AM, Walter D=C3=B6rwald =

> <[email protected]>
> wrote:
>
>> On 6 Mar 2018, at 0:53, Anthony Tuininga wrote:
>>
>> What is cx_Oracle?
>>
>> cx_Oracle is a Python extension module that enables access to Oracle
>> Database for Python 3.x and 2.x and conforms to the Python database =

>> API 2.0
>> specifications with a number of enhancements.
>>
>> I get an error when upgrading:
>>
>> pip install --upgrade cx_Oracle
>> Collecting cx_Oracle
>>   Downloading cx_Oracle-6.2.tar.gz (237kB)
>>     100% =

>> |=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=
=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=
=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=
=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88| =

>> 245kB 2.5MB/s
>> Installing collected packages: cx-Oracle
>>   Found existing installation: cx-Oracle 6.1
>>     Uninstalling cx-Oracle-6.1:
>>       Successfully uninstalled cx-Oracle-6.1
>>   Running setup.py install for cx-Oracle ... error
>>     Complete output from command =

>> /Users/walter/pyvenvs/default/bin/python3.6 -u -c "import setuptools, =

>> tokenize;__file__=3D'/private/var/folders/hg/5rsj4705065b3cyxdftzd48w0=
000gn/T/pip-build-ovkqpskf/cx-Oracle/setup.py';f=3Dgetattr(tokenize, =

>> 'open', open)(__file__);code=3Df.read().replace('\r\n', =

>> '\n');f.close();exec(compile(code, __file__, 'exec'))" install =

>> --record =

>> /var/folders/hg/5rsj4705065b3cyxdftzd48w0000gn/T/pip-a0f8egs7-record/i=
nstall-record.txt =

>> --single-version-externally-managed --compile --install-headers =

>> /Users/walter/pyvenvs/default/include/site/python3.6/cx-Oracle:
>>     running install
>>     running build
>>     running build_ext
>>     building 'cx_Oracle' extension
>>     creating build
>>     creating build/temp.macosx-10.13-x86_64-3.6
>>     creating build/temp.macosx-10.13-x86_64-3.6/src
>>     creating build/temp.macosx-10.13-x86_64-3.6/odpi
>>     creating build/temp.macosx-10.13-x86_64-3.6/odpi/src
>>     clang -Wno-unused-result -Wsign-compare -Wunreachable-code =

>> -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall =

>> -Wstrict-prototypes -arch x86_64 -DCXO_BUILD_VERSION=3D6.2 =

>> -Iodpi/include -Iodpi/src -I/usr/local/include =

>> -I/usr/local/opt/openssl/include -I/usr/local/opt/sqlite/include =

>> -I/Users/walter/pyvenvs/default/include =

>> -I/usr/local/Cellar/python/3.6.4_3/Frameworks/Python.framework/Version=
s/3.6/include/python3.6m =

>> -c src/cxoBuffer.c -o =

>> build/temp.macosx-10.13-x86_64-3.6/src/cxoBuffer.o
>>     src/cxoBuffer.c:17:10: fatal error: 'cxoModule.h' file not found
>>     #include "cxoModule.h"
>>              ^~~~~~~~~~~~~
>>     1 error generated.
>>     error: command 'clang' failed with exit status 1
>>
>>     ----------------------------------------
>>   Rolling back uninstall of cx-Oracle
>> Command "/Users/walter/pyvenvs/default/bin/python3.6 -u -c "import =

>> setuptools, =

>> tokenize;__file__=3D'/private/var/folders/hg/5rsj4705065b3cyxdftzd48w0=
000gn/T/pip-build-ovkqpskf/cx-Oracle/setup.py';f=3Dgetattr(tokenize, =

>> 'open', open)(__file__);code=3Df.read().replace('\r\n', =

>> '\n');f.close();exec(compile(code, __file__, 'exec'))" install =

>> --record =

>> /var/folders/hg/5rsj4705065b3cyxdftzd48w0000gn/T/pip-a0f8egs7-record/i=
nstall-record.txt =

>> --single-version-externally-managed --compile --install-headers =

>> /Users/walter/pyvenvs/default/include/site/python3.6/cx-Oracle" =

>> failed with error code 1 in =

>> /private/var/folders/hg/5rsj4705065b3cyxdftzd48w0000gn/T/pip-build-ovk=
qpskf/cx-Oracle/
>>
>> [=E2=80=A6]
>>
>> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>


> -----------------------------------------------------------------------=
-------
> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

--=_MailMate_B1B9373F-09BB-4A82-8768-1EC5C47A317D_=
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/xhtml; charset=3Dutf-8"=
>
</head>
<body>
<div style=3D"font-family:sans-serif"><div style=3D"white-space:normal">
<p dir=3D"auto">On 6 Mar 2018, at 18:19, Anthony Tuininga wrote:</p>

</div>
<div style=3D"white-space:normal"><blockquote style=3D"border-left:2px so=
lid #777; color:#777; margin:0 0 5px; padding-left:5px"><p dir=3D"auto">H=
i Walter,<br>
<br>
This error is due to the fact that cxoModule.h is a file with a new<br>
extension so it wasn't covered by MANIFEST.in.<br>
I have corrected that and<br>
also uploaded a revised source package so this should be corrected now.<b=
r>
Apologies for the inconvenience!</p>
</blockquote></div>
<div style=3D"white-space:normal">

<p dir=3D"auto">Thanks! Now the installation worked on my Mac.</p>

<p dir=3D"auto">However on a (german) Windows 10, we get the following er=
ror:</p>

<pre style=3D"background-color:#F7F7F7; border-radius:5px 5px 5px 5px; ma=
rgin-left:15px; margin-right:15px; max-width:90vw; overflow-x:auto; paddi=
ng:5px" bgcolor=3D"#F7F7F7"><code style=3D"background-color:#F7F7F7; bord=
er-radius:3px; margin:0; padding:0" bgcolor=3D"#F7F7F7">C:\Users\hannes&g=
t;pip install cx_Oracle
Collecting cx_Oracle
  Downloading cx_Oracle-6.2-2.tar.gz (240kB)
    100% |=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=
=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=
=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=
=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=
| 245kB 1.6MB/s
Installing collected packages: cx-Oracle
  Running setup.py install for cx-Oracle ... error
Exception:
Traceback (most recent call last):
  File "c:\users\hannes\appdata\local\programs\python\python36\lib\site-p=
ackages\pip\compat\__init__.py", line 73, in console_to_str
    return s.decode(sys.__stdout__.encoding)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0x94 in position 93: =
invalid start byte

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "c:\users\hannes\appdata\local\programs\python\python36\lib\site-p=
ackages\pip\basecommand.py", line 215, in main
    status =3D self.run(options, args)
  File "c:\users\hannes\appdata\local\programs\python\python36\lib\site-p=
ackages\pip\commands\install.py", line 342, in run
    prefix=3Doptions.prefix_path,
  File "c:\users\hannes\appdata\local\programs\python\python36\lib\site-p=
ackages\pip\req\req_set.py", line 784, in install
    **kwargs
  File "c:\users\hannes\appdata\local\programs\python\python36\lib\site-p=
ackages\pip\req\req_install.py", line 878, in install
    spinner=3Dspinner,
  File "c:\users\hannes\appdata\local\programs\python\python36\lib\site-p=
ackages\pip\utils\__init__.py", line 676, in call_subprocess
    line =3D console_to_str(proc.stdout.readline())
  File "c:\users\hannes\appdata\local\programs\python\python36\lib\site-p=
ackages\pip\compat\__init__.py", line 75, in console_to_str
    return s.decode('utf_8')
UnicodeDecodeError: 'utf-8' codec can't decode byte 0x94 in position 93: =
invalid start byte
</code></pre>

</div>
<div style=3D"white-space:normal"><blockquote style=3D"border-left:2px so=
lid #777; color:#777; margin:0 0 5px; padding-left:5px"><p dir=3D"auto">A=
nthony<br>
<br>
On Tue, Mar 6, 2018 at 4:02 AM, Walter D=C3=B6rwald &lt;walter@livinglogi=
c.de&gt;<br>
wrote:<br>
</p>
<blockquote style=3D"border-left:2px solid #777; color:#999; margin:0 0 5=
px; padding-left:5px; border-left-color:#999"><p dir=3D"auto">On 6 Mar 20=
18, at 0:53, Anthony Tuininga wrote:<br>
<br>
What is cx_Oracle?<br>
<br>
cx_Oracle is a Python extension module that enables access to Oracle<br>
Database for Python 3.x and 2.x and conforms to the Python database API 2=
=2E0<br>
specifications with a number of enhancements.<br>
<br>
I get an error when upgrading:<br>
<br>
pip install --upgrade cx_Oracle<br>
Collecting cx_Oracle<br>
  Downloading cx_Oracle-6.2.tar.gz (237kB)<br>
    100% |=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=
=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=
=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=
=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=
| 245kB 2.5MB/s<br>
Installing collected packages: cx-Oracle<br>
  Found existing installation: cx-Oracle 6.1<br>
    Uninstalling cx-Oracle-6.1:<br>
      Successfully uninstalled cx-Oracle-6.1<br>
  Running setup.py install for cx-Oracle ... error<br>
    Complete output from command /Users/walter/pyvenvs/default/bin/python=
3.6 -u -c "import setuptools, tokenize;__file__=3D'/private/var/folders/h=
g/5rsj4705065b3cyxdftzd48w0000gn/T/pip-build-ovkqpskf/cx-Oracle/setup.py'=
;f=3Dgetattr(tokenize, 'open', open)(__file__);code=3Df.read().replace('\=
r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --re=
cord /var/folders/hg/5rsj4705065b3cyxdftzd48w0000gn/T/pip-a0f8egs7-record=
/install-record.txt --single-version-externally-managed --compile --insta=
ll-headers /Users/walter/pyvenvs/default/include/site/python3.6/cx-Oracle=
:<br>
    running install<br>
    running build<br>
    running build_ext<br>
    building 'cx_Oracle' extension<br>
    creating build<br>
    creating build/temp.macosx-10.13-x86_64-3.6<br>
    creating build/temp.macosx-10.13-x86_64-3.6/src<br>
    creating build/temp.macosx-10.13-x86_64-3.6/odpi<br>
    creating build/temp.macosx-10.13-x86_64-3.6/odpi/src<br>
    clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-commo=
n -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -arch x86_64=
 -DCXO_BUILD_VERSION=3D6.2 -Iodpi/include -Iodpi/src -I/usr/local/include=
 -I/usr/local/opt/openssl/include -I/usr/local/opt/sqlite/include -I/User=
s/walter/pyvenvs/default/include -I/usr/local/Cellar/python/3.6.4_3/Frame=
works/Python.framework/Versions/3.6/include/python3.6m -c src/cxoBuffer.c=
 -o build/temp.macosx-10.13-x86_64-3.6/src/cxoBuffer.o<br>
    src/cxoBuffer.c:17:10: fatal error: 'cxoModule.h' file not found<br>
    #include "cxoModule.h"<br>
             ^~~~~~~~~~~~~<br>
    1 error generated.<br>
    error: command 'clang' failed with exit status 1<br>
<br>
    ----------------------------------------<br>
  Rolling back uninstall of cx-Oracle<br>
Command "/Users/walter/pyvenvs/default/bin/python3.6 -u -c "import setupt=
ools, tokenize;__file__=3D'/private/var/folders/hg/5rsj4705065b3cyxdftzd4=
8w0000gn/T/pip-build-ovkqpskf/cx-Oracle/setup.py';f=3Dgetattr(tokenize, '=
open', open)(__file__);code=3Df.read().replace('\r\n', '\n');f.close();ex=
ec(compile(code, __file__, 'exec'))" install --record /var/folders/hg/5rs=
j4705065b3cyxdftzd48w0000gn/T/pip-a0f8egs7-record/install-record.txt --si=
ngle-version-externally-managed --compile --install-headers /Users/walter=
/pyvenvs/default/include/site/python3.6/cx-Oracle" failed with error code=
 1 in /private/var/folders/hg/5rsj4705065b3cyxdftzd48w0000gn/T/pip-build-=
ovkqpskf/cx-Oracle/<br>
<br>
[=E2=80=A6]<br>
<br>
Servus,<br>
Walter<br>
<br>
------------------------------------------------------------<br>
------------------<br>
Check out the vibrant tech community on one of the world's most<br>
engaging tech sites, Slashdot.org! <a href=3D"http://sdm.link/slashdot" s=
tyle=3D"color:#999">http://sdm.link/slashdot</a><br>
_______________________________________________<br>
cx-oracle-users mailing list<br>
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org<br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-users" =
style=3D"color:#999">https://lists.sourceforge.net/lists/listinfo/cx-orac=
le-users</a><br>
<br>
</p>
</blockquote></blockquote><br><blockquote style=3D"border-left:2px solid =
#777; color:#777; margin:0 0 5px; padding-left:5px"><p dir=3D"auto">-----=
-------------------------------------------------------------------------=
<br>
Check out the vibrant tech community on one of the world's most<br>
engaging tech sites, Slashdot.org! <a href=3D"http://sdm.link/slashdot___=
____________________________________________" style=3D"color:#777">http:/=
/sdm.link/slashdot_______________________________________________</a><br>=

cx-oracle-users mailing list<br>
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org<br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-users" =
style=3D"color:#777">https://lists.sourceforge.net/lists/listinfo/cx-orac=
le-users</a></p>
</blockquote></div>
<div style=3D"white-space:normal">
</div>
</div>
</body>
</html>

--=_MailMate_B1B9373F-09BB-4A82-8768-1EC5C47A317D_=--


--===============5115569449831942593==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
--===============5115569449831942593==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

--===============5115569449831942593==--