Get Oracle DBMS_Output from Python's cx_Oracle library

gistfile1.py

import cx_Oracle
 
conn = cx_Oracle.Connection("userid/password@tns")
curs = conn.cursor()
curs.callproc("dbms_output.enable")
 
sqlCode = """
some long
sql code 
with dbms_output
"""
 
curs.execute(sqlCode)
 
statusVar = curs.var(cx_Oracle.NUMBER)
lineVar = curs.var(cx_Oracle.STRING)
while True:
  curs.callproc("dbms_output.get_line", (lineVar, statusVar))
  if statusVar.getvalue() != 0:
    break
  print lineVar.getvalue()

Very nice. With cx_Oracle v5.2 and Oracle 11g, however, I get a segfault unless I provide an explicit parameter (buffer_size) for dbms_output.enable.

That is:

curs.callproc("dbms_output.enable", (None,)) # or explicit integer size

Awesome !!! thanks a lot for this wonderful example . It definitely helps those who are beginners .