# Fireruby and stored procedures

**URL:** <https://www.ruby-forum.com/t/fireruby-and-stored-procedures/59905>\
**Category:** Ruby\
**Created:** [May 8, 2006, 12:53pm UTC](https://www.ruby-forum.com/t/fireruby-and-stored-procedures/59905 "2006-05-08T12:53:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![michael](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/4bbf92/32.png) [@michael](https://www.ruby-forum.com/u/michael)\
**Post date:** [May 8, 2006, 12:53pm UTC](https://www.ruby-forum.com/t/fireruby-and-stored-procedures/59905/1 "2006-05-08T12:53:24Z")

</div>

Hi,

I’ve got a question about stored procedures and fireruby.

I try to run one with  
sql= ‘EXECUTE PROCEDURE PROC(1, null)’  
s= Statement.new(@db\_fire, tx, sql, 3)  
s.execute

but it doesn’t work:  
…  
message length error (encountered 0, expected 116)  
Unsuccessful execution caused by system error that does not preclude  
successful execution of subsequent statements  
SQL Code = -901  
Firebird Code = 335544358

Isn’t this the way to call a procedured in a ruby script?

In an other program (flamerobin) the procedure works.

Thanks  
Michael