# Your code here
from sqlalchemy import create_engine
import cx_Oracle
engine_oracle = create_engine('oracle://admin:whatever@localhost:1521/xe')

I am getting error and not able to connect using create_engine

ValueError Traceback (most recent call last) in () 1 import cx_Oracle
----2 engine_oracle = create_engine('oracle://admin:whatever@localhost:1521/xe')
3

C:\Users\nitinahu\AppData\Local\conda\conda\envs\Tableau-Python-Server\lib\site-packages\sqlalchemy\engine__init__.pyc in create_engine(args, kwargs) 385 strategy = kwargs.pop('strategy', default_strategy) 386 strategy = strategies.strategies[strategy] --> 387 return strategy.create(args, **kwargs) 388 389

C:\Users\nitinahu\AppData\Local\conda\conda\envs\Tableau-Python-Server\lib\site-packages\sqlalchemy\engine\strategies.pyc in create(self, name_or_url, kwargs) 86 87 # create dialect ---> 88 dialect = dialect_cls(dialect_args) 89 90 # assemble connection arguments

C:\Users\nitinahu\AppData\Local\conda\conda\envs\Tableau-Python-Server\lib\site-packages\sqlalchemy\dialects\oracle\cx_oracle.pyc in init(self, auto_setinputsizes, exclude_setinputsizes, auto_convert_lobs, threaded, allow_twophase, coerce_to_decimal, coerce_to_unicode, arraysize, **kwargs) 705 if hasattr(self.dbapi, 'version'): 706 self.cx_oracle_ver = tuple([int(x) for x in --> 707 self.dbapi.version.split('.')]) 708 else: 709 self.cx_oracle_ver = (0, 0, 0)

ValueError: invalid literal for int() with base 10: '0b2'

# Paste the output here pd.show_versions() here

Comment From: TomAugspurger

From the traceback, this seems to be unrelated to pandas. You might try https://www.sqlalchemy.org/support.html, looks like they recommend the docs and StackOverflow as first stops.