I have a txn table which is having 2 million rows every month i am loading data into that using stored procedure. I need to delete the transactions using the following if it failed during my process and i used to load again .

```
Table TXN structure

TXN_ID    NUMBER primary key 
TXN_AMT   number
YEAR    varchar2
MONTH   varchar2

```

Can i used bulk collect here, but in where clause i need

```
DELETE FROM TXN WHERE YEAR=cYear and Month=cMonth 

```

please advice how i can make it fast