From christian.hoffmann at wsl.ch  Wed Dec 20 14:40:24 2006
From: christian.hoffmann at wsl.ch (christian.hoffmann at wsl.ch)
Date: Wed, 20 Dec 2006 14:40:24 +0100 (CET)
Subject: [Rd] DBI + ROracle problem with parser ?? (PR#9424)
Message-ID: <20061220134024.36DDD57334@slim.kubism.ku.dk>

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



[Rd] DBI + ROracle problem with parser ?? (PR#9424)
christian.hoffmann at wsl.ch