python - 在python中将cx_Oracle.LOB数据转换为字符串

Question

我有这个 list :

['ThisText', <cx_Oracle.LOB object at 0x02FDC080>]

Lst[1] 内容:

This is a string but as clob

我从这个查询结果中填充列表，如下所示:

import cx_Oracle

dsn_tns = cx_Oracle.makedsn('mario.connex.ro', '1529', service_name='EAIUAT')
conn = cx_Oracle.connect(user=r'LOGGING_DB05', password='passw0rd', dsn=dsn_tns)

c = conn.cursor()
c.execute("select column1, column2 from DB_Table where column3 = '1234'")

lst = []


for i in c:
    for j in i:
        lst.append(j)

表结构是:

Column1 = varchar
Column2 = clob
Column3 = varchar

我想将 clob 值从 lst[1] 转换为字符串

str = ''.join(lst[1])

收到错误:

TypeError: can only join an iterable

打印 lst[1] 类型:

print(type(lst[1]))
<class 'cx_Oracle.LOB'>

有没有办法将 cx_Oracle.LOB 值转换为字符串？

Answer 1

已解决:使用 cx.oracle.LOB.read() 方法检索 LOB 数据。

str = ''.join(lst[3].read())