search

rowland / fb

Firebird Extension Library for Ruby
64 stars 35 forks source link

How to run stored procedures? #16

Closed josefrichter closed 8 years ago

josefrichter commented 12 years ago

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

rowland commented 12 years ago

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 8 years ago

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 8 years ago

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