On 28 Lip, 20:02, Vincent Vega <lemm...@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 -- http://mail.python.org/mailman/listinfo/python-list
