Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Updating/deleting rows using ROracle does not complete

user231May 9 2017 — edited May 9 2017

I have successfully connected to an Oracle DB using ROracle and am able to run both select and inset queries on the data - e.g: dbGetQuery(conOut, "insert into TEST1 values(:1,:2,:3,:4,:5,:6,:7,:8)",df).

However when I attempt to either delete or update rows then R hangs - both of the following lines cause this issue:

dbGetQuery(conOut, "update TEST1 set RUN_STATUS = 'COMPLETE' where IX= '2'")

dbGetQuery(conOut, "delete from TEST1 where IX = '2'")

I definitely have write access to the TEST1 table - I can successfully insert rows with ROracle, and can run those update/delete statements successfully with Oracle SQL Developer.

Any idea how to get the update and delete working?

This post has been answered by Syedsalmancs110 on May 9 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2017

Added on May 9 2017

#r-technologies

2 comments

3,693 views