Full_Name: Christian Hoffmann Version: 2.4.0 OS: Win 2000 Submission from: (NULL) (193.134.202.252)
Database queries using the combination DBI + ROracle are handicapped by quirks in the pipeline between the textual representation of the query and the database engine Oracle. Comments and linefeed at start are interfering: dbGetQuery(conn, query): works: dbGetQuery(conn, "select * from dual") dbGetQuery(conn, "select * from dual /* comment */") dbGetQuery(conn, "select /* comment */ * from dual") doesn't: dbGetQuery(conn, "\nselect * from dual") dbGetQuery(conn, "select\n * from dual") dbGetQuery(conn, "/* comment */ select * from dual") ______________________________________________ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
