# Anyone know how to pass a reference cursor INTO a stored pro

**URL:** <https://www.ruby-forum.com/t/anyone-know-how-to-pass-a-reference-cursor-into-a-stored-pro/77570>\
**Category:** Ruby\
**Created:** [November 28, 2006, 10:06pm UTC](https://www.ruby-forum.com/t/anyone-know-how-to-pass-a-reference-cursor-into-a-stored-pro/77570 "2006-11-28T22:06:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vinsonizer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/848f3c/32.png) [@vinsonizer](https://www.ruby-forum.com/u/vinsonizer)\
**Post date:** [November 28, 2006, 10:06pm UTC](https://www.ruby-forum.com/t/anyone-know-how-to-pass-a-reference-cursor-into-a-stored-pro/77570/1 "2006-11-28T22:06:46Z")

</div>

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