[GENERAL] Problem with function that returns a cursor

[Eduardo Muñoz]

I'm new to pgSQL and I'm having some trouble with a
function. I keep getting the following error:

org.postgresql.util.PSQLException: ERROR: cursor
"<unnamed portal 1>" does not exist

This is the function:

CREATE OR REPLACE FUNCTION ret_user(pusername
"varchar")
  RETURNS refcursor AS
$BODY$
DECLARE
    ccursor refcursor;
BEGIN
    open ccursor for    
        select username, 
                password, 
                idrole 
        from user
        where username = quote_literal($1); 
    
        RETURN ccursor;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;


This is the JDBC code:

CallableStatement statement = null;
        ResultSet rs = null;
        Connection connection =
ConnectionPool.getConnection(saJNDI);
        try{
            statement = connection.prepareCall("{? =
call ret_user(?)");
            statement.registerOutParameter(1,
Types.OTHER);
            statement.setObject(2, "munoze");
            statement.execute();
            rs = (ResultSet)statement.getObject(1);
            while(rs.next()){
                System.out.println(rs.getString(1));
                System.out.println(rs.getString(2));
                System.out.println(rs.getString(3));
            }
            rs.close();
            statement.close();
        } catch(SQLException e){

        }

I hope you can help me



__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/ 

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend