From: Jason  Vogel <jasonvogel@...>
Date: 2006-11-29T06:05:13+09:00
Subject: Anyone know how to pass a reference cursor INTO a stored proc via OCI8

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