How to fetch the RefCursor in via ODBC?? - Mailing list pgsql-odbc

From Harry Yau
Subject How to fetch the RefCursor in via ODBC??
Date
Msg-id 3F02A670.7AD731A0@aurasound.com.hk
Whole thread Raw
List pgsql-odbc
Hi All,
  I wrote a function to return a RefCursor of a temp table as below:

    CREATE FUNCTION reffunc(refcursor, varchar(10), varchar(10))
        RETURNS refcursor AS '
        BEGIN
          EXECUTE ''create local temp table tablexxx
                    (repno character(15), date date)'';
          insert into tablexxx (repno, date) VALUES ( $2, now() );
          insert into tablexxx (repno, date) VALUES ( $3, now() );
          OPEN $1 for EXECUTE '' SELECT * FROM tablexxx '';
          RETURN $1;
          EXECUTE '''';
        END;
    ' LANGUAGE 'plpgsql';

It work fine on psql, at least it work as I expected. I call this
function by following command on psql:

        BEGIN;
          SELECT reffunc('funccursor', 'AAA', 'BBB' );
          FETCH ALL FROM funccursor;
        COMMIT;

However, when I try to call this function via ODBC ( namely in the
Borland DBExplorer ). It got none information for me! I am wondoring
is ODBC supporting RefCursor, since the FAQ of GBorg said the ODBC
only support simple data type. Therefore, does ODBC support
refcursor??

PS: My psqlODBC version is 07.03.0100
    My psql version is  7.3.1
Harry Yau
MIS HK





pgsql-odbc by date:

Previous
From: Nagaraja Sadar
Date:
Subject: How to can i make ,y system as psql database server????????
Next
From: Hiroshi Inoue
Date:
Subject: Re: A few problems with the ODBC driver