Facing this error while installing oracle to write sql based python code in both CMD prompt and also in Pycharm.
Please give answers
tried to install cx-Oracle in cmd prompt and Pycharm. But facing issue in building wheel Building wheel for cx-Oracle (pyproject.toml) did not run successfully. exit code: 1
On
cx_Oracle has been superseded by python-oracledb so prebuilt binaries for newer Python versions are only available with python-oracledb! Take a look at the upgrade notes. Depending on your requirements you can make use of the new thin mode which doesn't require Oracle Client libraries to be installed.
Navigate to following URL https://visualstudio.microsoft.com/visual-cpp-build-tools/ and download the build tools. Restart the terminal and proceed with executing the command again.