From: "Berger, Daniel" <Daniel.Berger@...>
Date: 2006-03-29T00:47:08+09:00
Subject: Re: Oracle Stored Procedures - Out Vars

> -----Original Message-----
> From: KUBO Takehiro [mailto:kubo@jiubao.org] 
> Sent: Monday, March 27, 2006 4:53 PM
> To: ruby-talk ML
> Subject: Re: Oracle Stored Procedures - Out Vars
> 
> 
> Hi,
> 
> Vance Heron <heron@jpl.nasa.gov> 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)

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

Regards,

Dan