No Guide to use this library for Stored Procedure

Question

No Guide to use this library for Stored Procedure

jaychanda opened this issue 5 years ago · 2 comments

I have checked this library, i am not able to use this library with stored procedure. can you help me with examples

Answer 1 · 2019-05-28T10:30:07.000Z

This library does not support stored procedures fully yet.

Calling stored procedures with input-parameters only should work though. You have to enclose the call in braces, e.g.

odbc::PreparedStatementRef ps = conn->prepareStatement("{CALL myproc(?, ?)}"); ps->setInt(1, 100); ps->setInt(2, 200); ps->executeUpdate();

I haven't tested it yet though.

Answer 2 · 2023-10-31T14:44:13.000Z

Hi, I came to the issue tracking system to ask about this. Has any support for been added for getting output from a stored procedure? If not, are there any workarounds I can use in the mean time?