Oracle proc : ArgumentError (interning empty string)

Hi,

I am trying to access oracle proc.

Code as below :

require “ruby-plsql”
OracleConnection.establish_connection “oracle_#{RAILS_ENV}”
plsql.connection =
OracleConnection.connection.raw_connection.connection
cursor = plsql.connection.parse <<-EOS
BEGIN
user(:empid, :terms, :List, :rooms);
END;
EOS
cursor.bind_param(’:empid’,‘0001234’,‘IN’)
cursor.bind_param(’:terms’,’’,‘OUT’)
cursor.bind_param(’:List’,’’,‘OUT’)
cursor.bind_param(’:rooms’,’’,‘OUT’)

cursor.exec
puts cursor[’:terms’]
puts cursor[’:List’]
puts cursor[’:rooms’]
cursor.close


I am not able to retrieve the OUT params. When the line cursor[’:terms’]
gets executed. I get error message as :

ArgumentError (interning empty string):
C:/jruby-1.4.0/lib/ruby/gems/1.8/gems/ruby-plsql-0.4.3/lib/plsql/jdbc_connection.rb:298:in
get_bind_variable' C:/jruby-1.4.0/lib/ruby/gems/1.8/gems/ruby-plsql-0.4.3/lib/plsql/jdbc_connection.rb:115:in[]’
app/models/oracle_connection.rb:147:in get_terms_rooms_list' app/controllers/secure/ccrp_controller.rb:8:inindex’

Checked the file in gem ruby-plsql-0.4.3\lib\plsql\jdbc_connection.rb.
@statement.registerOutParameter is not getting executed as condition
below fails
if metadata[:in_out] =~ /OUT/ .

If I comment the above line, i am able to get the results from out
params ,cursor[’:terms’] etc…

Am I setting the bind_params incorrect?

Kindly help resolve.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs