[問題] cx_Oracle BLOB 寫入 資料庫

作者: ctr1 (【積π】)   2020-12-16 14:41:59
小弟遇到一個怪問題
使用cx_Oracle連接資料庫
conn = cx_Oracle.connect(os.getenv('ID'), os.getenv('PASSWORD'),
os.getenv('DBCONN_STR'))
cur = conn.cursor()
# production env
sql = ('insert into Tab ( \
FILENAME, WAFERLOT, SLOT, NAME,TXNTIME, \
WAFER, DBSCAN, PREDRESULT, \
CDT, PLANT, REMARK, STEPNAME, AOLOT, DIESIZE)'
'values (:filename, :waferlot, :slot, :name, :txntime, \
:wafer, :dbscan, :predresult, \
:cdt, :plant, :remark, :stepname, :aolot, :diesize)')
# map
作者: ctr1 (【積π】)   2020-12-16 14:43:00
WAFER,DBSCAN這兩個欄位DB是blob

Links booklink

Contact Us: admin [ a t ] ucptt.com