I have appropriate permissions and other queries work (e.g., creating a table, querying a table, dropping a table). However, when I try to send "DELETE FROM Q_ERPA_TEST", I receive a result as if the rows have been deleted (see results below), but there is actually no impact on the table. I have tried dbSendQuery, dbSendStatement, and dbExecute. FYI, I'm running R 4.0.5 with ROracle 1.3-1.1 and DBI 1.1.1
Thanks for any help!
dbSendQuery Results:
Statement: DELETE FROM Q_ERPA_TEST
Rows affected: 14213
Row count: 0
Select statement: FALSE
Statement completed: TRUE
OCI prefetch: FALSE
Bulk read: 1000
Bulk write: 1000