I keep getting the following error when I try to execute the cell in a Jupyter notebook on VSCode
con = cx_Oracle.connect("/@DB")
DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See https://oracle.github.io/odpi/doc/installation.html#linux for help
But the same works fine when I run it in Jupyter Lab.
Sometimes stuff just doesn't work in some IDEs, i am not sure what your question is, i suggest using anaconda (and maybe spyder specifically) it has worked for me with everything so far, but i don't know about cx_Oracle.
Unable to connect using cx_Oracle in a Jupyter notebook on VSCode