Oracle Stored Procedures - Out Vars

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

Hi,

Vance H. [email protected] 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)

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs