Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cx_Oracle does not close connection with clob if exception raise

3651332Feb 22 2018 — edited Mar 5 2018

Hi there!

I have very strange error with cx_Oracle 6.1

Here is my code

import cx_Oracle

conn = cx_Oracle.connect('mbank','cnfkby','pro800-2n.ora.mmbank.ru:1521/CHIN')

cursor = conn.cursor()

res = cursor.callfunc('mbank.test_null', cx_Oracle.CLOB, keywordParameters={})

---

mbank.test_null raises simple exception (and nothing else)

---

after that if i try to close connection i get

"cx_Oracle.DatabaseError: DPI-1054: connection cannot be closed when open statements or LOBs exist"

---

it happens despite closing cursor, or calling del res, or declaring clob = cursor.var(cx_Oracle.CLOB), putting it insted of cx_Oracle.CLOB and after del clob

May be someone knows how to solve it? It seems that there is one LOB exists but i cann't get it.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2018
Added on Feb 22 2018
4 comments
5,030 views