Forum: Ruby Fireruby and stored procedures

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Michael (Guest)
on 2006-05-08 14:53
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
This topic is locked and can not be replied to.