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 <[email protected]> wrote:
From: Merlin Moncure <[email protected]>
Subject: Re: [GENERAL] Getting Out Parameter in the application using libpq
To: "Ehsan Haq" <[email protected]>
Cc: [email protected]
Date: Friday, September 11, 2009, 12:08 PM
On Fri, Sep 11, 2009 at 12:31 AM, Ehsan Haq <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
