Hi,
Is it possible to call stored procedures stored in MySql using QtSql ?
Printable View
Hi,
Is it possible to call stored procedures stored in MySql using QtSql ?
In oracle a procedure call with an in, inout and out parameter would be something as:
Code:
query->prepare("begin myProcedure(?,?,?) end;"); query->bindValue(0, "foo", QSql::In); query->bindValue(1, 1234, QSql::InOut); query->bindValue(2, 0, QSql::Out); query->exec(); int p3 = query->boundValue(2).toInt();
I'm not sure about MySQL, but I think the query syntax would instead be:
Code:
query->prepare("call myProcedure(?,?,?);");