Thanks Jason,
here is my code
import cx_Oracle
db = cx_Oracle.connect('xx','x','')
cursor=db.cursor()
#cursor.execute('set long 5000')
#sqlen="""set long 5000"""
#cursor.execute(sqlen)
sqtext="""select TExt from sq_updates where action_id= '851151'"""
cursor.execute(sqtext)
rettext
An example of your code would help. According to the cx_oracle docs at
http://www.python.net/crew/atuining/cx_Oracle/html/index.html under the LOB
Objects heading:
6. LOB Objects
*NOTE*: This object is an extension the DB API. It is returned whenever
Oracle CLOB, BLOB and BFILE columns are fetch
I am trying to fetch a CLOB datatype with with cx_Oracle and I can seem to
get it to work.
I was able to fetch the text from the db with sql commands but i can fetch
in a python code.
I get this output.
[(,)]
when I run my code.
any way to find out how to go around this?
__
