Oracle Stored Procedures - Out Vars


#1

Can anyone help me with the syntax for retriving an ‘out’
variable from an Oracle Stored Procedure?

I’m able to succesfully call several stored procedures,
and can pass values in - both by putting the argument
into the SQL statment, or by using a ? in the stmt
then passing the value when I execute it, but have
not been able to retrieve the ‘out’ value.

I’ve tried sth.fetch()[0] ,and sth.get()

Any help will be appreciated.

Thanks,
Vance


#2

Hi,

Vance H. removed_email_address@domain.invalid writes:

Can anyone help me with the syntax for retriving an ‘out’
variable from an Oracle Stored Procedure?

I’m able to succesfully call several stored procedures,
and can pass values in - both by putting the argument
into the SQL statment, or by using a ? in the stmt
then passing the value when I execute it, but have
not been able to retrieve the ‘out’ value.

I’ve tried sth.fetch()[0] ,and sth.get()

ruby-dbi doesn’t support out parameters.
Use a driver specific function:
sth.func(:bind_value, 0)