[Rd] DBI + ROracle problem with parser ?? (PR#9424)

[christian.hoffmann at wsl.ch]

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")