# ODBC: Obtaining output params

**URL:** <https://www.ruby-forum.com/t/odbc-obtaining-output-params/80051>\
**Category:** Ruby\
**Created:** [December 21, 2006, 1:00am UTC](https://www.ruby-forum.com/t/odbc-obtaining-output-params/80051 "2006-12-21T01:00:58Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\
**Post date:** [December 21, 2006, 1:00am UTC](https://www.ruby-forum.com/t/odbc-obtaining-output-params/80051/1 "2006-12-21T01:00:58Z")

</div>

I’m fairly new to Ruby, as well as using the ODBC library. So far, I’ve  
had very little problems using it… running queries, stored procs,  
etc. However, I cannot seem to get an output parameter from a stored  
proc that I run.

Here’s a basic example of my DB connection and queries…

* * *

require ‘odbc’

dbcon = ODBC.connect( host, username, password )

## outVar = -1 queryStatement = “call sp\_TestSP( 2, #{@outVar} )” query = dbcon.prepare( queryStatement ) query.execute()

At this point I can retrieve the return value if the stored proc  
returns anything, but I cannot for my life figure out how to get the  
output parameter that was set. @outVar is not changed, though I know  
the stored proc is doing it internally.

Any help on retreiving an output param that is set would be great!

Thanks for any help!