dbExecute sql delete statement blocking r console

General
1

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?

2

This topic was automatically closed 42 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.