From: | Mark French <frenchmb(at)tpg(dot)com(dot)au> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Callable Statements |
Date: | 2003-07-01 11:24:09 |
Message-ID: | 3F016F59.1070705@tpg.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Nic | 2003-07-01 11:26:41 | Re: Callable Statements |
Previous Message | Daniel Phlander | 2003-07-01 10:34:35 | db |