如何在Python中读取cx_Oracle.LOB数据?
发布时间:2020-12-16 23:04:14 所属栏目:Python 来源:网络整理
导读:我有这个代码: dsn = cx_Oracle.makedsn(hostname,port,sid) orcl = cx_Oracle.connect(username + '/' + password + '@' + dsn) curs = orcl.cursor() sql = "select TEMPLATE from my_table where id ='6'" curs.execute(sql) rows = curs.fetchall() pri
我有这个代码:
dsn = cx_Oracle.makedsn(hostname,port,sid) orcl = cx_Oracle.connect(username + '/' + password + '@' + dsn) curs = orcl.cursor() sql = "select TEMPLATE from my_table where id ='6'" curs.execute(sql) rows = curs.fetchall() print rows template = rows[0][0] orcl.close() print template.read() 当我打印行时,我得到这个: [(<cx_Oracle.LOB object at 0x0000000001D49990>,)] 但是,当我打印template.read()时,我得到这个错误:
如何获取和读取这些数据?谢谢. 解决方法
我发现,如果在使用cx_Oracle.LOB.read()方法之前连接到Oracle是关闭的,则会发生这种情况.
orcl = cx_Oracle.connect(usrpass+'@'+dbase) c = orcl.cursor() c.execute(sq) dane = c.fetchall() orcl.close() # before reading LOB to str wkt = dane[0][0].read() 我得到:DatabaseError:无效句柄! orcl = cx_Oracle.connect(usrpass+'@'+dbase) c = orcl.cursor() c.execute(sq) dane = c.fetchall() wkt = dane[0][0].read() orcl.close() # after reading LOB to str (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |