Callable Statements
От | Mark French |
---|---|
Тема | Callable Statements |
Дата | |
Msg-id | 3F016F59.1070705@tpg.com.au обсуждение исходный текст |
Ответы |
Re: Callable Statements
|
Список | pgsql-jdbc |
Hi, I currently trying to use Callable statments but have been unable to get any rows returned in the result set. The function and code is as follows : CREATE OR REPLACE FUNCTION verify_version_name(BIGINT) RETURNS REFCURSOR AS ' DECLARE v_load_id ALIAS FOR $1; v_entrys REFCURSOR; BEGIN OPEN v_entrys FOR SELECT COUNT(vers.name) FROM ots_stage_scheme_version stg_ver, ots_scheme_version vers WHERE stg_ver.load_id = v_load_id AND stg_ver.name != vers.name; RETURN v_entrys; END; ' LANGUAGE 'plpgsql'; CallableStatement proc = conn.prepareCall("{ ? = call verify_version_name (?) }"); proc.registerOutParameter(1, Types.OTHER); proc.setLong(2, 59); proc.execute(); ResultSet result = (ResultSet) proc.getObject(1); System.out.println(result); while(result.next()) { System.err.println("Value : " + result.getLong(1)); } Does anybody have any ideas as to why the result set is empty (I am using the development driver) . Cheers Mark
В списке pgsql-jdbc по дате отправления: