ROracle (version 0.5-12)

dbCommit-methods: DBMS Transaction Management

Description

Commits or roll backs the current transaction in an Oracle connection

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://stat.bell-labs.com/RS-DBI.

See Also

Oracle, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbReadTable.

Examples

drv <- dbDriver("Oracle")
con <- dbConnect(drv, "user/password@SID")
rs <- dbSendQuery(con, 
      "delete * from PURGE as p where p.wavelength<0.03")
if(dbGetInfo(rs, what = "rowsAffected") > 250){
  warning("dubious deletion -- rolling back transaction")
  dbRollback(con)
}