Anyone know how to pass a reference cursor INTO a stored proc via OCI8

ruby-talk
1

I'm trying...

tcursor = OCI8::Cursor.new(OCI8::@@env, OCI8::@svc, OCI8::@ctx)

     plsql.bind_param(':st_tier_label_in', tcursor, OCI8::Cursor)

Error:

ruby ste_OCI8.rb

C:/Develop/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`gem_original_require': ./ste_get_product_version_list.rb:70: parse
error, unexpected tCVAR (SyntaxError)
tcursor = OCI8::Cursor.new(OCI8::@@env, OCI8::@svc, OCI8::@ctx)
                                      ^
./ste_get_product_version_list.rb:70: parse error, unexpected tIVAR
tcursor = OCI8::Cursor.new(OCI8::@@env, OCI8::@svc, OCI8::@ctx)
                                                  ^
./ste_get_product_version_list.rb:70: parse error, unexpected tIVAR
tcursor = OCI8::Cursor.new(OCI8::@@env, OCI8::@svc, OCI8::@ctx)
                                                              ^ from
C:/Develop/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require'
        from ste_OCI8.rb:3

Thanks,
Jason