# Oracle proc : ArgumentError (interning empty string)

**URL:** <https://www.ruby-forum.com/t/oracle-proc-argumenterror-interning-empty-string/193758>\
**Category:** Ruby\
**Created:** [August 23, 2010, 11:41pm UTC](https://www.ruby-forum.com/t/oracle-proc-argumenterror-interning-empty-string/193758 "2010-08-23T23:41:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sharnel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecc23a/32.png) [@sharnel](https://www.ruby-forum.com/u/sharnel)\
**Post date:** [August 23, 2010, 11:41pm UTC](https://www.ruby-forum.com/t/oracle-proc-argumenterror-interning-empty-string/193758/1 "2010-08-23T23:41:36Z")

</div>

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:in`index’

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.