奇怪的Oracle错误：“格式无效的文本” [英] strange Oracle error: "invalid format text"

问题描述

我正在尝试使用这段代码从DATA_TYPE = NUM​​BER（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） 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屋！