If there is no Oracle connectino app, is it possible to load cx_Oracle into the python environment so I can connect via puthon?

Questions
1

I’m using n8n.io for developing my workflows

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

cx_Oracle was renamed to/replaced by python-oracledb several years ago. The main feature of this new release is that it doesn’t need any extra Oracle client libraries (e.g. Instant Client) installed. With a simple ‘pip’ install you can connect to your Oracle database. The quick start install is at 2. Installing python-oracledb — python-oracledb 2.5.0b1 documentation

4

Thanks Christopher. Can the pip install be done in n8n.io?

5

When I try to do “python -m pip install oracledb --upgrade --user” I get “AttributeError: module ‘lib’ has no attribute 'X509_V_FLAG_NOTIFY_POLICY”. I’ve tried everything on Google to try to fix this but nothing works.

6

I tried it on a different machine and got this error,
python3 -m pip install oracledb --upgrade --user
Requirement already satisfied: oracledb in ./Library/Python/3.9/lib/python/site-packages (2.4.1)
Requirement already satisfied: cryptography>=3.2.1 in ./Library/Python/3.9/lib/python/site-packages (from oracledb) (43.0.3)
Requirement already satisfied: cffi>=1.12 in /usr/local/lib/python3.9/site-packages (from cryptography>=3.2.1->oracledb) (1.15.0)
Requirement already satisfied: pycparser in /usr/local/lib/python3.9/site-packages (from cffi>=1.12->cryptography>=3.2.1->oracledb) (2.21)
WARNING: Error parsing dependencies of bleach: Expected matching RIGHT_PARENTHESIS for LEFT_PARENTHESIS, after version specifier
tinycss2 (>=1.1.0<1.2) ; extra == ‘css’
~~~~~~~~^

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.