Entity Framework 2 : Error during python build phase: ERROR: Could not find a version that satisfies the requirement oracle

[duey_hoang]

Using Visual Studio Code with Dynatrace extension v2.6.1 and python 3.12

when adding oracle dependency to setup.py (install_requires=["dt-extensions-sdk","oracle"]), the project cannot be built due to the above error, even the package existed inside the folder structure. The problem is not there when i add other dependency like requests (for example . install_requires=["dt-extensions-sdk","requests"]).

thank you.

[Mike_L · Accepted solution]

I think it used to be called cx_oracle and nowadays the Python library Oracle recommends is oracledb.

[duey_hoang]

thank you Mike. there is one thing i forgot to add. everything built and worked as expected with oracle package on local machine. The only issue is when it is time to pack it up, build it and distribute to remote oneagent host, that is when we have to put the oracle dependency in the setup.py so that it comes along to the oneagent host. that is the time when we have that issue error.

[Mike_L · Accepted solution]

I don't think "pip install oracle" is the one you're looking for though, I assume you installed another one locally, which is why it works.

Also, make sure that you set additional environments if required to get all compiled code. See info here: https://developer.dynatrace.com/extensions-v2/dynatrace-extensions-vscode/settings/#python-environme...

[duey_hoang]

i gave up on dynatrace extension on vscode market. I just used python3.10 and dynatrace CLI on terminal. it works for me that way.

thank you Mike for the tips.