rowland/fb

How to run stored procedures?

josefrichter opened this issue · 3 comments

josefrichter commented

Hi, is there a way to run Firebird's stored procedures using this gem, please? Thank you.

rowland commented

I honestly don't know. I only use selectable stored procedures, similar to "select gen_id(some_seq, 1) from rdb$database;"

It may be that you could use "execute procedure" as in

conn.execute("execute procedure foo('bar');")

Please report back if you find something that works.

LevKhramov commented

Hi! I'm trying to use conn.execute("execute procedure foo('bar');) and receive this:
Fb::Error: Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements message length error (encountered 0, expected 8).
Can you help me, please? Thank you.

rowland commented

If that doesn't work, I don't know what will. Sorry.