dbExecute sql delete statement blocking r console

hello Everyone,

I'm trying to remove some records on a oracle table.
In an sql env the code is working properly
delete from R_IN_RANGE_AVG where weekday_Num = to_char(trunc(sysdate), 'd').

but when i try to in r console it remain running :

rem <- dbExecute(FS, "delete from R_IN_RANGE_AVG where weekday_Num = to_char(trunc(sysdate), 'd')" )

any one an id what could be wrong here?