Re: Getting a ResultSet for a refcursor element.

From: Nic Ferrier <nferrier(at)tapsellferrier(dot)co(dot)uk>
To: Barry Lind <barry(at)xythos(dot)com>
Cc: Dave Cramer <Dave(at)micro-automation(dot)net>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Getting a ResultSet for a refcursor element.
Date: 2002-10-10 18:24:06
Message-ID: 87ptui17ax.fsf@pooh-sticks-bridge.tapsellferrier.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Barry Lind <barry(at)xythos(dot)com> writes:

> Dave,
>
> True, but that has nothing to do with refcursor's. refcursors and SRFs
> (set returning functions) are two different features. I thought this
> thread was all about refcursors, so I am still unsure what Nic meant by
> the comment below.
>
> thanks,
> --Barry
>
> Dave Cramer wrote:
> > Alledgedly 7.3 now supports returning result sets from a function
> >
> > Dave
> > On Thu, 2002-10-10 at 11:33, Barry Lind wrote:
> >
> >>Nic,
> >>
> >>What do you mean by "the CallableStatement handling is not setup yet"?
> >>Current code should support CallableStatements such that the example you
> >>give should work (except of course for returning a ResultSet object :-)

On my machine it fails. I just built 7.3 out of CVS. I presume there
is a bug somewhere. I'll take a look at it and give you an update.

Nic

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Brett 2002-10-10 18:35:02 Re: Taking advantage of prepared statement performance
Previous Message Barry Lind 2002-10-10 17:48:02 Re: Taking advantage of prepared statement performance