Re: Getting Out Parameter in the application using libpq

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

IS

BEGIN

   outvarchar:='This is Out String';

   RETURN 1;

END getOutVarchar;

iris=> SELECT getOutVarchar('outVar');

 getoutvarchar

---------------

             1

(1 row)

My question is how can I Select "outVar" so that it is available in my application as a resultset.

Thanks

Ehsan

--- On Fri, 9/11/09, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
Subject: Re: [GENERAL] Getting Out Parameter in the application using libpq
To: "Ehsan Haq" <ehsan_haq98(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Date: Friday, September 11, 2009, 12:08 PM

On Fri, Sep 11, 2009 at 12:31 AM, Ehsan Haq <ehsan_haq98(at)yahoo(dot)com> wrote:
>
> Hi,
>    I am looking for a way to get the OUT parameters of a FUNCTION/PROCEDURE in my application (C++) using C libpq library. I can get the result set of an OUT parameter having REFCURSOR data type through an explicit FETCH ALL from "YYYY" but for OUT parameter of type integer/varchar I dont have a clue. Can anyone tell me how it is done or suggest any work around for this?

name your cursor:  also, remember that your cursor is only good for
duration of transaction.

> Using the following code I can get the refcursor.
>
> CREATE OR REPLACE
> Function getAddresses
> (
> pName IN varchar2, outCursor refcursor

outCursor := 'outcur';

[...]

FETCH all FROM outcur;

see:
http://www.postgresql.org/docs/8.4/interactive/plpgsql-cursors.html#PLPGSQL-CURSOR-USING

merlin