Re: Stored Procedure returns a ResultSet

Now the 7.4 pgsql and  jdbc driver are  beta version, they should have some
problems!
So I need a stable driver!

I want to use the  7.3.4  pgsql and pg73jdbc3.jar!

You say they support CallableStatement, but  I can't get the right result!

the java program:

           conn.setAutoCommit(false);

           cstmt = conn.prepareCall(m_query);

           cstmt.registerOutParameter(1, Types.OTHER);
           cstmt.execute();

           ResultSet resultSet = (ResultSet)cstmt.getObject(1);


        the Function return refcursor:

        CREATE OR REPLACE FUNCTION Fuc_test4Query()
        RETURNS refcursor AS '
        DECLARE
            r_Result refcursor;
        BEGIN
            r_QuerySQL := ''select ID,Name from Handset '';
            OPEN r_Result FOR EXECUTE r_QuerySQL;
            return r_Result;
        END;
        '
        language 'plpgsql';


Otherwise,  the fuc_test4query1
How to do with java?
 thanks!

the Function return setof

  CREATE OR REPLACE FUNCTION public.fuc_test4query1()
    RETURNS setof test AS
  '
  DECLARE
   r_Result record;
  BEGIN
   r_QuerySQL := \'select ID,Name  from Handset \';
   FOR r_Result IN execute r_QuerySQL LOOP

   RETURN next r_Result;

   END LOOP;

   return NULL;
  END;
  '
    LANGUAGE 'plpgsql' VOLATILE;