How to execute oracle store procedure using Jruby

Dear all

Sorry that I am very green to jruby. Is there any example to show how to
execute store procedure in oracle. I have used google to search, but the
result is not in my expectation.

I have a store procedure (PROC_UTIL_CHK_HKID_FORMAT) which have 2 params
param-1 char input
param-2 integer output

I have tried the following, but failed…so depress now
require ‘dbi’

jdbc_url = “dbi:Jdbc:oracle:thin:@host:12345:AAAA1234”
jdbc_driver = “oracle.jdbc.driver.OracleDriver”
dbh = DBI.connect(jdbc_url, “ABC”, “ABC”, { “driver” => jdbc_driver } )

db_read_str = ‘BEGIN :out1 := PROC_UTIL_CHK_HKID_FORMAT(hkid=>:in1);
puts db_read_str
sth_db = dbh.prepare(db_read_str)
sth_db.bind_param(“out1”, ’ ’ * 5 )
sth_db.bind_param(“in1”, “A1234563”)
puts sth_db.func(“bind_value”, “out1”)

The following error happened
sth_db.bind_param(“out1”, ’ ’ * 5 )
NameError: uninitialized constant
from /appl/lis/jruby-1.2.0/lib/ruby/1.8/irb/ruby-token.rb:54:in
const_missing' from /appl/lis/jruby-1.2.0/lib/ruby/gems/1.8/gems/dbd-jdbc-0.0.5/lib/dbd/jdbc/statement.rb:45:inbind_param’
bind_param' from (irb):25:inirb_binding’

Please help me…Thank you so much


Also see raimonds blog for some good oracle info