Insert Data To Oracle Table By Python

This is an example to read the data from a CSV file and insert the data to a Oracle table using python script.

 

 

 # Program Name: insert_data.py# Date: 2009-08-13import cx_Oracleimport datetimeconn_xxx = cx_Oracle.connect('xxx/xxx@TNS Name')curs_xxx = conn_xxx.cursor()row_wid = 111severity_cd = 'Warning'created_by = 'stu'now = datetime.datetime.now()error_file = 'C:/Documents and Settings/user name/Desktop/DeleteFlagTest/error_code.csv'f = open(error_file)lines = f.readlines()for i in range(1,len(lines)): error_code = lines[i][:4] error_desc = lines[i][5:-1] sql = """insert into TABLE_NAME(ROW_WID,ERROR_CODE,ERROR_CODE_DESCRIPTION_TXT,SEVERITY_CD,CREATED_ON_DT,CHANGED_ON_DT,CREATED_BY,CHANGED_BY)values ( :row_wid, :error_code,:error_desc,:severity_cd,:created_on_dt,:changed_on_dt,:created_by,:changed_by)""" bindVar = {'row_wid':row_wid,'error_code':error_code, 'error_desc':error_desc,'severity_cd':severity_cd,/ 'created_on_dt':now,'changed_on_dt':now,'created_by':created_by,'changed_by':created_by} curs_xxx.execute(sql,bindVar)# print sql row_wid = row_wid + 1 conn_xxx.commit()curs_xxx.close()conn_xxx.close()print 'The error codes have been inserted. Please check result!'