从oracle获取数据插入mysql的脚本,大神帮忙看一下代码哪里有问题
sql语句:Insert_dblinkSql = insert into kt_collectoracle (owner,db_link,username,host,created) values ('%s','%s','%s','%s','%s')
def insertMysqlseghist(self,oracleDatadb,oracleDatacur,OracleDataTuple):
for OracleData in OracleDataTuple:
try:
oracleDatacur.execute(self.Insert_dblinkSql%(OracleData[0],
OracleData[1],OracleData[2],OracleData[3],OracleData[4]))
oracleDatadb.commit()
except Exception as e:
oracleDatadb.rollback()
logger_data_message.debug('error: '+str(e)+'\n')