Connect to Oracle db remotly

Frappe Framework
1

Hi all;
I need to integrate with remote oracle db;make a connection to receive data to my application from the remote oracle db; can any one help what are the steps to make a connection with it ??

2

Do you mean from within Python application code you intend to write, or are you expecting something in the user interface to do that for you?

3

Python application code

4

Connecting to Oracle Database in Python

5

actually i followed these instructions but when start query i got the following error

( ModuleNotFoundError: No module named ‘cx_Oracle’)

6

actually i followed these instructions but when start query i got the following error

( ModuleNotFoundError: No module named ‘cx_Oracle’)

7

Sorry for the delay.

Did you run the correct command for Widows …

python -m pip install cx_Oracle --upgrade

… or for Unix …

python3 -m pip install cx_Oracle --upgrade

… and saw them run free from error?

Did you ensure you have …

import cx_Oracle

… at the top of your file?

8

I am getting the same error.
It is working perfectly when I execute the .py file in command line. But, getting error when using in frappe doctype.

Regards//Mijan

9

You should install it in the bench environment
source env/bin/activate