title: calling Oracle stored procedures in R - how to get the result set?
body: <p>Looking for an example for calling Oracle stored proc using R, and returning a result set.</p>
  
  <p>I'm using RJDBC library, dbGetQuery to call Sybase procs and point the results to a variable, and this works the same for Oracle select stmts.  However, I don't see how to get this to return Oracle result sets from an Oracle stored proc (i.e., from the sys_refcursor out param).  The only examples I find for retrieving data from Oracle involve "select columns from table".</p>
  
  <p>Searching in google was led me to "<em>dbCallProc – Call an SQL stored procedure</em>" which sounds very promising, but every ref I found to it indicates that it is "<em>Not yet implemented.</em>"</p>
  
  <p>Any pointers or examples for using procs?  Greatly appreciated.  Don't know why Oracle always has to be such a challenge for retrieving result sets....</p>
  
  <p>Thanks,
  Mike</p>
  
  <p><strong>UPDATE</strong>: I'd take an example that simply called an Oracle stored proc.  Are Oracle procs simply not supported currently in RJDBC?</p>