Print value CLOB via cx_Oracle

[Vincent Vega]

Hi,

I call function in Oracle database use cx_Oracle.
In standard I define:

db = cx_Oracle.connect(username, password, tnsentry)
cursor = db.cursor()

I create variable 'y' (result function 'fun_name') and call function
'fun_name':

y = cursor.var(cx_Oracle.CLOB)
cursor.callfunc(fun_name, cx_Oracle.CLOB, y)

When I print variable 'y' I receive:
<cx_Oracle.CLOB with value <cx_Oracle.LOB object at 0x00999999>>

How can I get value variable 'y'???
How read <cx_Oracle.LOB object at 0x00999999>???


Vincent Vega




Note:
Off course y.read() does not work, cause 'y'is CLOB not LOB.
(see datatypes table in site: http://www.oracle.com/technology/pub/articles/prez-python-queries.html)

 

[Vincent Vega]

Hi,

I call function in Oracle database use cx_Oracle.
In standard I define:

db       = cx_Oracle.connect(username, password, tnsentry)
cursor  = db.cursor()

I create variable 'y' (result function 'fun_name') and call function
'fun_name':

y   = cursor.var(cx_Oracle.CLOB)
cursor.callfunc(fun_name, cx_Oracle.CLOB, y)

When I print variable 'y' I receive:
<cx_Oracle.CLOB with value <cx_Oracle.LOB object at 0x00999999>>

How can I get value variable 'y'???
How read <cx_Oracle.LOB object at 0x00999999>???

Vincent Vega

Note:
Off course y.read() does not work, cause 'y'is CLOB not LOB.
(see datatypes table in site:http://www.oracle.com/technology/pub/articles/prez-python-queries.html)

The solution is simple:

print y.getvalue()

(see: http://cx-oracle.sourceforge.net/html/variable.html)

Thanks!

Vincent Vega