From: Vance Heron <heron@...>
Date: 2006-03-26T18:01:43+09:00
Subject: 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