output in cx_Oracle 6.2 and below for variable.getvalue() when there's no value, None. in 6.3 I am getting the above error "IndexError: cxoVar_getSingleValue: array size exceeded".
import cx_Oracle
c = cx_Oracle.connect(
dsn=cx_Oracle.makedsn("oracle1120", 1521), user="scott", password="tiger")
cursor = c.cursor()
try:
cursor.execute("drop table foo")
except:
pass
cursor.execute("""
create table foo(
id integer primary key,
data varchar(50)
)
""")
cursor.execute("insert into foo (id, data) values (1, 'hi')")
var = cursor.var(cx_Oracle.STRING)
cursor.execute("""
UPDATE foo set data='there' WHERE id=2 RETURNING foo.id INTO :ret_0
""", {"ret_0": var})
print(var.getvalue())
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4