Oracle Stored Procedures - Out Vars

Looks like we need to add StatementHandle#bind_param_inout. I'll put in
a feature request.




-----Original Message-----
From: KUBO Takehiro []
Sent: Monday, March 27, 2006 4:53 PM
To: ruby-talk ML
Subject: Re: Oracle Stored Procedures - Out Vars


Vance Heron <> 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)