Displaying 1 result from an estimated 1 matches for "dostoredprocedurefetch".
2006 Oct 27
0
RMySQL and stored procedures
..."196608" )
where 196608 is a combination of CLIENT_MULTI_RESULTS and
CLIENT_MULTI_STATEMENTS as mentioned in the
mysql_real_connect() documentation. Without these flags stored
procedures calls do not run at all.
I also do fetching the results in a loop - as suggested in the doc, so:
doStoredProcedureFetch <- function( connection, sql ) {
res <- dbSendQuery( connection, sql )
data <- fetch( res, n=-1 )
repeat {
fetch( res, n=-1 )
if( dbHasCompleted( res ) ) break ;
}
data
}
However, sometimes I get the error message:
"RS-DBI driver: (could not run statement: Lost con...