We are pleased to announce the latest update of the open source ROracle package, version 1.3-2, with the following enhancements:
- Compatibility with R 3.6.0
- Use ora.encoding for DML when specified - this allow specifying whether data is encoded in UTF8 or natively. This is used to preserve data in character strings in various national languages.
- Revised INSTALL file to be more user friendly across various platforms based on customers feedback
- Specify the table column type using ora.type attribute in data.frame when using dbWriteTable. For example, one can specify integer and double to be stored as a number column; and PosixCt for date time to specify date, time stamp, time stamp with time zone or time stamp with local time zone.
ROracle provides high performance and scalable interaction from R with Oracle Database.ROracle binaries specific to Windows and Linux can be downloaded from the Oracle Technology Network.
We encourage ROracle users to post questions and provide feedback on the Oracle R Forum.
In addition to being a high performance database interface to Oracle Database from R for general use, ROracle supports database access for Oracle R Enterprise.