problems returning a resultset from a function
От | Leo Martin Orfei |
---|---|
Тема | problems returning a resultset from a function |
Дата | |
Msg-id | 20040904160747.66889.qmail@web51806.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: problems returning a resultset from a function
|
Список | pgsql-jdbc |
hi. I have a problem with postgres functions. I need return a resultset from a postgres function and browse the resultset in a java app. I try with this simple function: create function test() returns catalog.refcursor as' declare aux refcursor; BEGIN OPEN aux FOR SELECT name, address FROM table; RETURN aux; END; 'LANGUAGE 'plpgsql'; and the java CallableStatement cs = null; ResultSet rs = null; cs = con.prepareCall("{ ? = call test()}"); cs.registerOutParameter(1, java.sql.Types.OTHER); rs = cs.executeQuery(); rs.next(); System.out.println("name: " +rs.getString(1)); but throws te following error: cursor "<unnamed portal 1>" does not exist I try this too: Statement s = null; rs = s.executeQuery("select test()"); rs.next(); System.out.println("name: " +rs.getString(1)); and don't throws an error, but show me the following result: name: <unnamed portal 1> anybody can help me with this? thnx; __________________________________ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail
В списке pgsql-jdbc по дате отправления: