I’m diving into type hints and type hinting some of my code as I think it is a good practice. I have a function that takes both sqlalchemy and cx_Oracle connection/session objects. I was able to figure out the hinting for sqlalchemy here. Poked around some docs trying to figure it out with cx_Oracle to …
Tag: cx-oracle
Freezing/hanging when executing Oracle DB PL/SQL procedure in Python
Hello I created a PLSQL procedure to update or insert quantity in inventory table based on product Id and new inward qty. Below is my PLSQL procedure and it works fine when i try in sql developer. But when i trying to execute this in python it is stopped working and froze Kindly help. PLSQL Procedure: Python …
cx_Oracle SELECT statement with WHERE clause and single quote
WHat is wrong here , when I using single quote around username then I am getting this error . Answer
Connect to Oracle database using python from a Linux server (lxv)
In my local machine I have created a script in python that retrieves data from an Oracle database. The connection to the DB is done using cx_Oracle: When using SQL developer the connection is established using custom JDBC. Replicate procedure on a Linux server. I have created a python virtual environment with…
“libnnz19.so: cannot open shared object file: No such file or directory
I have installed cx_oracle(python3) and instant client 21_1 inside a container. When I try to first time I got this error So I have created lib under /python-env/instantclient_21_1/ and tried again, now I’m getting this error cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client librar…
cx_Oracle connection fails with ‘DPI-1047: Cannot locate a 64-bit Oracle Client library’
Problem use connection oracle to python source, oracle now is worked to other language php (oci) Error: Code: Answer Update: try the latest version of cx_Oracle see the release announcement. This version (which was renamed python-oracledb) doesn’t need Instant Client so the installation is easier. Here …
cx_Oracle.DatabaseError: DPI-1039: statement was already closed
Upgraded to latest Cx_Oracle release (5.1.3 to 7.1.3) and now all my code is broken. Problem appears to be occurring when attempting to pass a cursor. I’m getting correct data in the fetchall so I know it is connecting properly and returning a valid result. So I comment it out. In the other scripts I ca…