Forum Stats

  • 3,769,583 Users
  • 2,252,984 Discussions
  • 7,875,103 Comments

Discussions

cx_Oracle does not close connection with clob if exception raise

3651332
3651332 Member Posts: 3
edited Mar 5, 2018 8:48PM in Python

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.

Answers

This discussion has been closed.