Python-сообщество

pip install cx_Oracle
Collecting cx_Oracle
  Using cached cx_Oracle-5.3.tar.gz
Installing collected packages: cx-Oracle
  Running setup.py install for cx-Oracle ... error
    Complete output from command "c:\program files\python36\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\drno\\AppData\\Local\\Temp\\pip-build-jgeivctu\\cx-Oracle\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\drno\AppData\Local\Temp\pip-am47ubdl-record\install-record.txt --single-version-externally-managed --compile:
    running install
    running build
    running build_ext
    building 'cx_Oracle' extension
    creating build
    creating build\temp.win-amd64-3.6-12c
    creating build\temp.win-amd64-3.6-12c\Release
    creating build\temp.win-amd64-3.6-12c\Release\src
    cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -ID:\Databases\Oracle\product\12.2.0\dbhome_1\oci\include -ID:\Databases\Oracle\product\12.2.0\dbhome_1\rdbms\demo "-Ic:\program files\python36\include" "-Ic:\program files\python36\include" /Tcsrc/cx_Oracle.c /Fobuild\temp.win-amd64-3.6-12c\Release\src/cx_Oracle.obj -DBUILD_VERSION=5.3
    error: command 'cl.exe' failed: No such file or directory

    ----------------------------------------
Command ""c:\program files\python36\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\drno\\AppData\\Local\\Temp\\pip-build-jgeivctu\\cx-Oracle\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\drno\AppData\Local\Temp\pip-am47ubdl-record\install-record.txt --single-version-externally-managed --compile" failed with error code 1 in C:\Users\drno\AppData\Local\Temp\pip-build-jgeivctu\cx-Oracle\

   Using cached cx_Oracle-5.3.tar.gz
Installing collected packages: cx-Oracle
  Running setup.py install for cx-Oracle ... error
Exception:
Traceback (most recent call last):
  File "c:\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 0xe4 in position 100: invalid continuation byte
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "c:\python36\lib\site-packages\pip\basecommand.py", line 215, in main
    status = self.run(options, args)
  File "c:\python36\lib\site-packages\pip\commands\install.py", line 342, in run
    prefix=options.prefix_path,
  File "c:\python36\lib\site-packages\pip\req\req_set.py", line 784, in install
    **kwargs
  File "c:\python36\lib\site-packages\pip\req\req_install.py", line 878, in install
    spinner=spinner,
  File "c:\python36\lib\site-packages\pip\utils\__init__.py", line 676, in call_subprocess
    line = console_to_str(proc.stdout.readline())
  File "c:\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 0xe4 in position 100: invalid continuation byte

 #!/usr/bin/python
import cx_Oracle
ip='192.168.0.2'
port = 1521
SID = 'dboracle'
USERNAME='dboracle'
PASSWORD='pwd'
sql_script="""
SELECT sysdate from dual
"""
dsn_tns = cx_Oracle.makedsn(ip, port, SID)
print (dsn_tns)
conn = cx_Oracle.connect(USERNAME, PASSWORD, dsn_tns)
c = conn.cursor()
c.execute(sql_script)
for row in c:
    print (row[0], row[1])
conn.close()

 C:\Python36\python.exe C:/templates/DB/Oracle/Jobs.py
Traceback (most recent call last):
  File "C:/templates/DB/Oracle/Jobs.py", line 2, in <module>
    import cx_Oracle
ImportError: DLL load failed: %1 is not a valid Win32 application.