ODBC refcursor resultset

am 07.06.2010 06:16:58 von Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199A9INHYWEXMB2i nf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi List,

I am trying to execute a function which returns a Posgresql from ODBC clien=
t,
But my ODBC client could not able to recognize the Posgresql hence could no=
t able to retrieve the result set.
I am working with Posgresql 8.4 version.
I have few questions.

Do ODBC - Posgresql supports refcursor?

Do we have user guide or document on ODBC guide .

Thanks,
Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199A9INHYWEXMB2i nf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns:st1=3D"urn:schemas-microsoft-com:off=
ice:smarttags" xmlns=3D"http://www.w3.org/TR/REC-html40">

>

name=3D"place"/>

0.0pt;
font-family:Arial'>Hi List,

0.0pt;
font-family:Arial'>

0.0pt;
font-family:Arial'>I am trying to execute a function which returns a Posgre=
sql from
ODBC client,

0.0pt;
font-family:Arial'>But my ODBC client could not able to recognize the Posgr=
esql
hence could not able to retrieve the result set. p>

0.0pt;
font-family:Arial'>I am working with Posgresql 8.4 version. an>

0.0pt;
font-family:Arial'>I have few questions.

0.0pt;
font-family:Arial'>

0.0pt;
font-family:Arial'>Do ODBC – Posgresql supports refcursor?=

0.0pt;
font-family:Arial'>

0.0pt;
font-family:Arial'>Do we have user guide or document on ODBC guide . o:p>

0.0pt;
font-family:Arial'>

0.0pt;
font-family:Arial'>Thanks,

an
style=3D'font-size:10.0pt;font-family:Arial'>Ravi > size=3D2 face=3DArial> K=
atkar

0.0pt;
font-family:Arial'>

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199A9INHYWEXMB2i nf_--

Re: ODBC refcursor resultset

am 07.06.2010 06:20:03 von Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199AAINHYWEXMB2i nf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi List,

I am trying to execute a function which returns a refcursor from ODBC clie=
nt,
But my ODBC client could not able to recognize the refcursor hence could n=
ot able to retrieve the resultset.
I am working with Posgresql 8.4 version.

Do ODBC - Posgresql supports refcursor?

Do we have user guide or document on ODBC guide which can help.

Thanks,
Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199AAINHYWEXMB2i nf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns:st1=3D"urn:schemas-microsoft-com:off=
ice:smarttags" xmlns=3D"http://www.w3.org/TR/REC-html40">

name=3D"place"/>

'font-size:
12.0pt'>

0.0pt;
font-family:Arial'>Hi List,

0.0pt;
font-family:Arial'>

0.0pt;
font-family:Arial'>I am trying to execute a function which returns a color=3Dnavy> refcursor from=
ODBC
client,

0.0pt;
font-family:Arial'>But my ODBC client could not able to recognize the color=3Dnavy>refcursor hence=
could
not able to retrieve the resultset.

0.0pt;
font-family:Arial'>I am working with Posgresql 8.4 version. an>

=3D'font-size:
10.0pt;font-family:Arial;color:navy'>

0.0pt;
font-family:Arial'>

0.0pt;
font-family:Arial'>Do ODBC – Posgresql supports refcursor?=

0.0pt;
font-family:Arial'>

0.0pt;
font-family:Arial'>Do we have user guide or document on ODBC guide color=3Dnavy>which can help.<=
/o:p>

0.0pt;
font-family:Arial'>

0.0pt;
font-family:Arial'>Thanks,

an
style=3D'font-size:10.0pt;font-family:Arial'>Ravi > size=3D2 face=3DArial> K=
atkar

0.0pt;
font-family:Arial'>

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199AAINHYWEXMB2i nf_--

ODBC refcursor resultset

am 07.06.2010 08:49:40 von Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199ABINHYWEXMB2i nf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi List,

I am trying to execute a function which returns a refcursor from ODBC clien=
t,
But my ODBC client could not able to recognize the refcursor hence could no=
t able to retrieve the resultset.
I am working with Posgresql 8.4 version.

Do ODBC - Posgresql supports refcursor?

Do we have user guide or document on ODBC guide which can help.

Thanks,
Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199ABINHYWEXMB2i nf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns:st1=3D"urn:schemas-microsoft-com:off=
ice:smarttags" xmlns=3D"http://www.w3.org/TR/REC-html40">

name=3D"place"/>

=3D'font-size:
10.0pt;font-family:Arial;color:navy'>

N
style=3D'font-size:12.0pt'>Hi List,

I am trying to execute a function which returns a refcursor from ODBC clien=
t,

But my ODBC client could not able to recognize the refcursor hence could no=
t
able to retrieve the resultset.

I am working with Posgresql 8.4 version.

Do ODBC - Posgresql supports refcursor?

Do we have user guide or document on ODBC guide which can help.

Thanks,

Ravi Katkar face=3DArial>=

0.0pt;
font-family:Arial'>

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199ABINHYWEXMB2i nf_--

Re: ODBC refcursor resultset

am 07.06.2010 23:13:48 von Hiroshi Inoue

Ravi Katkar wrote:
>
>
> Hi List,
>
>
> I am trying to execute a function which returns a refcursor from ODBC
> client,
> But my ODBC client could not able to recognize the refcursor hence could
> not able to retrieve the resultset.

How would you handle refcursor in your ODBC client program?

regards,
Hiroshi Inoue

> I am working with Posgresql 8.4 version.
>
>
> Do ODBC - Posgresql supports refcursor?
>
> Do we have user guide or document on ODBC guide which can help.
>
>
> Thanks,
> Ravi Katkar
>
>
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc