Re: Stored procedures

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: Dave Cramer <Dave(at)micro-automation(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Stored procedures
Date: 2002-08-19 13:29:15
Message-ID: 1029763755.1192.10.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm using it, but the result from a stored procedure isn't updatable
On Mon, 2002-08-19 at 10:17, Dave Cramer wrote:
> Felipe,
>
> Only the dev driver on http://jdbc.postgresql.org supports updateable
> result sets.
>
> Dave
> On Mon, 2002-08-19 at 08:41, Felipe Schnack wrote:
> > I know that if I want to return resultsets from stored procedures in
> > PgSQL I should return REFCURSOR return type. But this doesn't return
> > updatable resultsets. How can I do that?
> > --
> >
> > Felipe Schnack
> > Analista de Sistemas
> > felipes(at)ritterdosreis(dot)br
> > Cel.: (51)91287530
> > Linux Counter #281893
> >
> > Faculdade Ritter dos Reis
> > www.ritterdosreis.br
> > felipes(at)ritterdosreis(dot)br
> > Fone/Fax.: (51)32303328
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--

Felipe Schnack
Analista de Sistemas
felipes(at)ritterdosreis(dot)br
Cel.: (51)91287530
Linux Counter #281893

Faculdade Ritter dos Reis
www.ritterdosreis.br
felipes(at)ritterdosreis(dot)br
Fone/Fax.: (51)32303328

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2002-08-19 13:49:47 Re: Error using JDBC2 postgres driver and DatabaseMetaData.getTables()
Previous Message Dave Cramer 2002-08-19 13:17:22 Re: Stored procedures