Re: [GENERAL] Getting Out Parameter in the application using libpq

2009-09-14 Thread Albe Laurenz
Ehsan Haq wrote: >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; > > iri

Re: [GENERAL] Getting Out Parameter in the application using libpq

2009-09-12 Thread Ehsan Haq
N 1" and not "This is Out String". Thanks Ehsan --- On Sat, 9/12/09, Merlin Moncure wrote: From: Merlin Moncure Subject: Re: [GENERAL] Getting Out Parameter in the application using libpq To: "Ehsan Haq" Cc: pgsql-general@postgresql.org Date: Saturday, September 12

Re: [GENERAL] Getting Out Parameter in the application using libpq

2009-09-12 Thread Merlin Moncure
On Fri, Sep 11, 2009 at 10:30 PM, Ehsan Haq 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 ge

Re: [GENERAL] Getting Out Parameter in the application using libpq

2009-09-11 Thread Ehsan Haq
re Subject: Re: [GENERAL] Getting Out Parameter in the application using libpq To: "Ehsan Haq" Cc: pgsql-general@postgresql.org Date: Friday, September 11, 2009, 12:08 PM On Fri, Sep 11, 2009 at 12:31 AM, Ehsan Haq wrote: > > Hi, >    I am looking for a way to get the OUT parameters o

Re: [GENERAL] Getting Out Parameter in the application using libpq

2009-09-11 Thread Merlin Moncure
On Fri, Sep 11, 2009 at 12:31 AM, Ehsan Haq 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

[GENERAL] Getting Out Parameter in the application using libpq

2009-09-10 Thread Ehsan Haq
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 "" but for OUT parameter of type integer/varchar I dont ha