Hello,
I am using Oracle 11g and Python 2.7 to insert data into my tables.
I have a list of dictionaries - example [ {"Date": "12/12/2012" , "CheckStatement" : "Yes"} , {"Date": "13/12/2012" , "CheckStatement" : "Yes"}]
I make a list of lists out it- example [["11/11/2017 5:06", "Yes"], ["11/11/2017 5:06", "Yes"]]
My DB table looks like -
Date (TIMESTAMP(6))
| CheckStatement (String)
|
|---|
| 11/11/2017 5:06 | Yes |
| 11/11/2017 5:06 | No |
| 11/11/2017 5:06 | Yes |
How do I execute the executemany() function so that my dates are filled with it?
Currently i get this error - ORA-01843: not a valid month