DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library

I’m having some issues when deploying on Azure, thing is i had to add a query to a database, if i run it local have no problem but when i try to deploy it on the web app im getting the following error:

DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found”. See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help

Im using cx-Oracle and i even included the folder into the docker but still getting the error message

Hi @st4tic0, welcome to the Streamlit community!

This sounds like a path issue of some sort, but I don’t know how to specifically resolve it (I’m not an Oracle user). I suspect that there is a setup step you are missing in your Dockerfile to make the Oracle client visible to Python.