Python 3.7 cx_Oracle ORA-01704: 字符串文字太長 PLS-00172: 字符串常值太長
import cx_Oracle
import os
os.environ['Path'] = r'D:\instantclient_18_5'
(user, passwd, oracle_url) = ('user', 'pass', '127.0.0.1:1521/TESTDB')
conn = cx_Oracle.connect(user, pwd, oracle_url)
cursor = conn.cursor()
# res 是長度大于3萬的字符串, 數(shù)據(jù)庫中類型為CLOB
report_id = 1
res = "abcd...."
sql_insert_current = "insert into data_temp values ('%s', '%s') "
cursor.execute(sql_cmd % (report_id, res)
import cx_Oracle
import os
os.environ['Path'] = r'D:\instantclient_18_5'
(user, passwd, oracle_url) = ('user', 'pwd', '127.0.0.1:1521/TESTDB')
conn = cx_Oracle.connect(user, passwd, oracle_url)
cursor = conn.cursor()
# res 是長度大于3萬的字符串
report_id = 1
res = "abcd...."
# res 是長度大于3萬的字符串, 數(shù)據(jù)庫中類型為CLOB
sql_insert_current = "insert into data_temp values (:report_id, :res) "
cursor.execute(sql_cmd, report_id=report_id, res=res)
