On Fri, 28 Sep 2007, David Gagnon wrote:
> I ran into this problem that look like a bug if someone can confirm and
> hopefully provide a workaround.
>
> I have a storedProcedure that use a refcursor + temp table to create a
> report. The problem is that the NUMERIC field 13 I get in my application is
> always NULL. When I run the stored procedure from PGADMINIII I can see that
> field 13 has value 5.5400000000000000.
>
You've provided a lot of very complicated code that no one can run, so
it's unlikely you're going to get any real useful help. You don't even
include the Java code that's used to setup and use this function which
would be nice if you believe it's a problem with the JDBC driver.
I don't know of any bugs in this area and once the refcursor is setup the
display process works pretty much like any other resultset, so it seems
unlikely there's a serious bug that leaves out data here. If you can put
together a small, self contained test case, I'll gladly take a look at it,
but I don't see anything immediately wrong in this area.
Kris Jurka