Re: 7.3 Cursors/ResultSets/CallableStatements

Barry,

I think notionally the idea would be to call a stored proc which
returned a cursor, and when result set's supported cursors this would be
feasible. I'm still not sure how we tell if the stored proc returned a
cursor?

Dave
On Mon, 2002-08-26 at 07:34, Barry Lind wrote:
> Larry,
>
> The jdbc driver will not support returning result sets from
> callableStatements in 7.3. You will need to use a regular
> Statement/Prepared Statement object and execute a 'select * from func()'
> sql statement. Off the top of my head, I'm not sure how the jdbc
> callableStatement syntax is supposed to handle resultsets.
>
> Dave, correct me if I am wrong here.
>
> thanks,
> --Barry
>
>
> Larry Riedel wrote:
>
> > I am interested in calling a stored procedure through
> > a CallableStatement and fetching a ResultSet a
> > few rows at a time. I have seen a few messages
> > suggesting all the pieces may be in place for doing
> > this kind of thing nicely in 7.3. Any idea when it
> > will become clear what will actually go into 7.3?
> >
> >
> > Larry
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>