I have spent many days trying to figure out the ORA-00936: missing expression error when using the executemany(). If I insert one row at a time, the insert works.
I have searched, read, and tried suggestions found on the internet but none of them seem to work.
I need help.
here is the table description:

```
ColumnName,ColID,PK,IndexPos,Null,DataType,Default,DefaultOnNull,Histogram,NumDistinct,NumNulls,Density,EncryptionAlg,Salt,Trigger,Virtual
YEARMONTH,1,1,1,N,DATE,,False,None,1997,0,0.0005,,,,False
PHASE,4,,,Y,VARCHAR2 (7 Char),,False,Frequency,5,0,0.00013,,,,False
INDEXVALUE,3,,,Y,NUMBER (3,2),,False,None,728,0,0.00137,,,,False
CLIMATEINDEX,2,2,2,N,VARCHAR2 (4 Char),,False,Frequency,3,0,0.00013,,,,False

```

The data is read from a csv file with python's csv reader and put into a list.
Here is the data:

```
file_data = [['1854-01-01', 'PDO', '0.11', 'POS'], ['1854-02-01', 'PDO', '-0.24', 'NEG'], ['1854-03-01', 'PDO', '-0.4', 'NEG'], ['1854-04-01', 'PDO', '-0.44', 'NEG'], ['2020-04-01', 'ONI', '0.28', 'NEUTRAL'], ['2020-04-01', 'PDO', '-1.33', 'NEG'], ['2020-05-01', 'PDO', '-0.7', 'NEG']]

```

This is the insert sql:

```
in_query = ('insert into myschema.monthly_climate_index(YEARMONTH, CLIMATEINDEX, INDEXVALUE, PHASE) values (DATE :YEARMONTH, :CLIMATEINDEX, :INDEXVALUE, :PHASE)')

```

This is the execute many command:

```
cursor.executemany(in_query, file_data)

```

The result is: ORA-00936: missing expression
THANK YOU!!!