Newby Question - accessing refcursor.

I'm just getting started with postgre and jdbc.

I have a stored procedure listed below.

I'm trying to fetch the data returned from the stored procedure with the
method listed below.
When I do, the execute() method throws the following exception:
ERROR: cursor "<unnamed portal 1>" does not exist

I'm not sure what is causing this error -
I suspect it may be because the stored procedure is returning the REFCURSOR
as an OUT parameter rather than as a RETURN parameter.

If this is the case, could someone show me the fix?
The person writing the stored procedures is having problems returning a
RETURN value
with OUT parameters.


Thanks.

Java code

    public void fetchUsers()
    {
        String query = "{call get_user_list( ?, ?, ? ) }";
        try
        {
            CallableStatement cs = dbConn.prepareCall( query );
            cs.registerOutParameter(1, java.sql.Types.JAVA_OBJECT);
            cs.registerOutParameter(2, java.sql.Types.INTEGER);
            cs.registerOutParameter(3, java.sql.Types.VARCHAR);
            cs.execute();
            ResultSet results = (ResultSet)cs.getObject(1);
            if( results != null)
            {
                while( results.next() )
                {
                    // Process row
                }
                results.close();
                cs.close();
            }
        }
        catch( Exception e)
        {
            System.out.println( "Error: " + e.getMessage()  );
        }

    }



Stored procedure

FUNCTION Get_User_List(OUT p_Users REFCURSOR, OUT p_Return_Code INTEGER, OUT
p_Return_Message VARCHAR(100)) RETURNS RECORD AS $$
DECLARE
   l_Rtn_Success              INTEGER := 0;
   l_Rtn_GeneralFailure       INTEGER := 99;

   l_Rtn_Success_Msg          VARCHAR(100) := 'Successful';
   l_Rtn_GeneralFailure_Msg   VARCHAR(100) := 'General Failure';

BEGIN

   p_Return_Code := l_Rtn_GeneralFailure;
   p_Return_Message := l_Rtn_GeneralFailure_Msg;

   OPEN p_Users FOR SELECT * FROM Users;

   p_Return_Code := l_Rtn_Success;
   p_Return_Message := l_Rtn_Success_Msg;

   RETURN;

END;
$$ LANGUAGE plpgsql;

--
View this message in context: http://www.nabble.com/Newby-Question---accessing-refcursor.-tp19680083p19680083.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.