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