[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Oracle Stored Procedures - Out Vars

Vance A Heron

3/26/2006 9:02:00 AM

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
1 Answer

KUBO Takehiro

3/27/2006 11:53:00 PM

0

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)

--
KUBO Takehiro
email: kubo@jiubao.org
web: http://www....
GnuPG fingerprint = 5F7B C8EF CA16 57D0 FDE1 9F47 C001 1F93 AC08 2262