Print value CLOB via cx_Oracle

[Vincent Vega]

On 28 Lip, 20:02, Vincent Vega <lemm... at gmail.com> wrote:
> 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