Hi guys,
Just a quick question: does DIO support Stored Procedure Call?
When I run that sql by hand
call getSubPackages(72,'name','asc',0,50);
in MySql workbench I get 1 row which is correct.
In my Rivet code I have:
if {[catch {
set sql {call getSubPackages(72,'name','asc',0,50);}
set res [DIO exec $sql]
log [$res errorinfo]
log [$res errorcode]
set numrows [$res numrows]
log $numrows
} err]} {
log "caught $err"
}
I get:
Nov 12 22:23:11:
Nov 12 22:23:11: 0
Nov 12 22:23:11: 0
No Errors, no rows.
Is there something specific to Stored Procedure?
I am using Mysql and Rivet 2.1 on Linux Suse.
Thank you,
Brice.
