title: ROracle dbGetQuery bind parameters by name
body: <p>I am trying to process a large number of queries with parameters in R using ROracle. I know which parameters appear in each query, but I don't know in which order they appear. I am therefore looking for a way to submit the parameters by name in each query. Sample code:</p>
  
  <pre><code>library(ROracle)
  
  # establish connection to DB
  drv &lt;- dbDriver("Oracle")
  con &lt;- dbConnect(drv, "User", "password", dbname = "DB")
  
  # create table
  createTab &lt;- "create table RORACLE_TEST(num1 number, num2 number)"
  dbGetQuery(con, createTab)
  
  # insert String
  insStr &lt;- "insert into RORACLE_TEST values(:row1, :row2)"
  dbGetQuery(con, insStr, data.frame(row2 = 0, row1 = 1))
  
  # check output
  dbGetQuery(con, "SELECT * FROM RORACLE_TEST")
  
  # Output is:
  #  NUM1 NUM2
  #1    0    1
  
  # Desired output should be:
  #  NUM1 NUM2
  #1    1    0
  </code></pre>
  
  <p>Any workaround for this will be appreciated except solutions of the kind</p>
  
  <pre><code>dbGetQuery(con,gsub(":row2", "0", gsub(":row1", "1", insStr)))
  </code></pre>
  
  <p>since this will not sanitize against sql injection (parameters will come from user input).</p>