* using log directory ‘/srv/hornik/tmp/CRAN_pretest/ROracle.Rcheck’ * using R Under development (unstable) (2024-10-31 r87278) * using platform: x86_64-pc-linux-gnu * R was compiled by Debian clang version 19.1.1 (1) Debian flang-new version 19.1.1 (1) * running under: Debian GNU/Linux trixie/sid * using session charset: UTF-8 * using option ‘--install=fake’ * checking for file ‘ROracle/DESCRIPTION’ ... OK * this is package ‘ROracle’ version ‘1.5-0’ * checking CRAN incoming feasibility ... [4s/4s] NOTE Maintainer: ‘Rajendra S. Pingte ’ No Authors@R field in DESCRIPTION. Please add one, modifying Authors@R: c(person(given = "Denis", family = "Mukhin", role = "aut"), person(given = c("David", "A."), family = "James", role = "aut"), person(given = "Jake", family = "Luciani", role = "aut"), person(given = c("Rajendra", "S."), family = "Pingte", role = "cre", email = "rajendra.pingte@oracle.com")) as necessary. Found the following (possibly) invalid URLs: URL: https://www.oracle.com/technetwork/indexes/documentation/index.html (moved to https://docs.oracle.com/en/) From: man/dbCommit-methods.Rd man/dbConnect-methods.Rd man/dbDriver-methods.Rd man/dbGetInfo-methods.Rd man/dbListConnections-methods.Rd man/dbReadTable-methods.Rd man/dbSendQuery-methods.Rd man/fetch-methods.Rd man/summary-methods.Rd Status: 301 Message: Moved Permanently For content that is 'Moved Permanently', please change http to https, add trailing slashes, or replace the old by the new URL. * checking package namespace information ... OK * checking package dependencies ... OK * checking if this is a source package ... OK * checking if there is a namespace ... OK * checking for executable files ... OK * checking for hidden files and directories ... OK * checking for portable file names ... OK * checking for sufficient/correct file permissions ... OK * checking serialization versions ... OK * checking whether package ‘ROracle’ can be installed ... [2s/2s] OK * checking package directory ... OK * checking for future file timestamps ... OK * checking DESCRIPTION meta-information ... OK * checking top-level files ... OK * checking for left-over files ... OK * checking index information ... OK * checking package subdirectories ... NOTE Problems with news in ‘NEWS’: Cannot process chunk/lines: Version 0.3-3 NOTE: Next major version will comply with the emerging common database interface DBI, if agreed by the R-SIG-DB. This will probably change the function names, but not the basic functionality. * Some minor clean up of the RS-DBI C code. * Updated the use of NAs in strings in the C code, according to the new 1.5.0 stricter rules. * added a PROTECT() when re-setting the length of output data.frame during fetching that could lead to random core dumps (thanks to Don MacQueen for reporting this pesky bug). * getInfo() on a connection object now also returns the password used on the connection (needed, e.g., in assignTable, see below). * A few fixes to assignTable.OraConnection: A bug in the SQL*Loader script that assignTable() creates to efficiently transfer data.frames to Oracle (the bug was that NAs in the last column caused SQL*Loader to fail); assingTable() now also provides the password in the call to SQL*Loader to avoid being prompted for it. Added an argument "batch=10000"; this is used to write.table() these many rows at a time from the data.frame in order to avoid huge memory build ups. It's still shamefully slow (due to write.table), but at least it won't exhaust memory. [Need to find an efficient alternative to write.table(), perhaps we need to write our own specialized C code?] * Extended the size of the internal connections parameters (user, password and dbname) to 1024 to allow users to embed the tnsnames.ora string, e.g., con <- dbConnect(Oracle(), "user/passwd@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=foo.misc.de)(PORT=1521))(CONNECT_DATA=(SID=TEST)) [this seems to be an undocumented "feature" that Oracle gurus use quite commonly when they don't have privileges to update the network config file $ORALCE_HOME/network/admin/tnsname.ora (thanks to Michael Mader for this trick!] * ifdef all S4/Splus' idioms if(IS_LIST(x)) x = AS_LIST(x). I'm not sure whether these should be PROTECTED in R, but since the idiom is only needed in S4/Splus5+, it's better not to have it in R. * Fixed a bug in SQLDataType.OraConnection (wrong signature). * Added dbObject validity checks to a bunch of the meta-data functions. * checking code files for non-ASCII characters ... OK * checking R files for syntax errors ... OK * checking whether the package can be loaded ... [0s/0s] OK * checking whether the package can be loaded with stated dependencies ... [0s/0s] OK * checking whether the package can be unloaded cleanly ... [0s/0s] OK * checking whether the namespace can be loaded with stated dependencies ... [0s/0s] OK * checking whether the namespace can be unloaded cleanly ... [0s/0s] OK * checking loading without being on the library search path ... [0s/0s] OK * checking whether startup messages can be suppressed ... [0s/0s] OK * checking use of S3 registration ... OK * checking dependencies in R code ... OK * checking S3 generic/method consistency ... OK * checking replacement functions ... OK * checking foreign function calls ... OK * checking R code for possible problems ... [3s/3s] OK * checking Rd files ... [0s/0s] OK * checking Rd metadata ... OK * checking Rd line widths ... OK * checking Rd cross-references ... OK * checking for missing documentation entries ... OK * checking for code/documentation mismatches ... OK * checking Rd \usage sections ... OK * checking Rd contents ... OK * checking for unstated dependencies in examples ... OK * checking line endings in shell scripts ... OK * checking line endings in C/C++/Fortran sources/headers ... OK * checking line endings in Makefiles ... OK * checking compilation flags in Makevars ... OK * checking for GNU extensions in Makefiles ... OK * checking for portable use of $(BLAS_LIBS) and $(LAPACK_LIBS) ... OK * checking use of PKG_*FLAGS in Makefiles ... OK * checking use of SHLIB_OPENMP_*FLAGS in Makefiles ... OK * checking pragmas in C/C++ headers and code ... OK * checking compilation flags used ... OK * checking compiled code ... OK * checking installed files from ‘inst/doc’ ... OK * checking examples ... SKIPPED * checking PDF version of manual ... [3s/3s] OK * checking HTML version of manual ... [1s/1s] OK * checking for non-standard things in the check directory ... OK * checking for detritus in the temp directory ... OK * DONE Status: 2 NOTEs