奇怪的Oracle错误:“格式无效的文本” [英] strange Oracle error: "invalid format text"
本文介绍了奇怪的Oracle错误:“格式无效的文本”的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试使用这段代码从DATA_TYPE = NUMBER(1,0)的列中获取一些数据:
I'm trying to fetch some data from a column whose DATA_TYPE=NUMBER(1,0) with this piece of code:
import cx_Oracle
conn = cx_Oracle.connect(usr, pwd, url)
cursor = conn.cursor()
cursor.execute("SELECT DELETED FROM SERVICEORDER WHERE ORDERID='TEST'")
print(cursor.fetchone()[0])
:
Traceback (most recent call last):
File "main.py", line 247, in <module>
check = completed()
File "main.py", line 57, in completed
deleted = cursor.fetchone()[0]
cx_Oracle.DatabaseError: OCI-22061: invalid format text [T
用 DATA_TYPE = VARCHAR2不替换的列替换 DELETED列
Replacing 'DELETED' column with one whose DATA_TYPE=VARCHAR2 does not throw such a complaint.
推荐答案
一种解决方法是将 time.sleep(1)$ c在
cursor.fetchone()
之前的$ c>:
A work-around is putting time.sleep(1)
before cursor.fetchone()
:
...
cursor.execute("SELECT DELETED FROM SERVICEORDER WHERE ORDERID='TEST'")
time.sleep(1)
print(cursor.fetchone()[0])
这篇关于奇怪的Oracle错误:“格式无效的文本”的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文