Re: Getting Out Parameter in the application using libpq

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Ehsan Haq <ehsan_haq98(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting Out Parameter in the application using libpq
Date: 2009-09-12 13:21:09
Message-ID: b42b73150909120621l7c5c5a6eh845fbbc64884cdb3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 11, 2009 at 10:30 PM, Ehsan Haq <ehsan_haq98(at)yahoo(dot)com> wrote:
>
> Hi,
>    I still don't get. How can I get the varchar OUT parameter in the application? For Example
>
> CREATE OR REPLACE
> Function getOutVarchar(outvarchar OUT varchar2) RETURN NUMBER

if, from libpq:

res = PQexec(conn, "SELECT * FROM getOutVarchar()");

the result should have a one column, one row result with a field
called outvarchar.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mohsen Pahlevanzadeh 2009-09-12 13:22:56 Re: dblink & 4 master operation
Previous Message Mohsen Pahlevanzadeh 2009-09-12 11:40:24 dblink & 4 master operation