| From: | federico <fissore(at)hyphen(dot)it> | 
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org | 
| Subject: | bug 1201 | 
| Date: | 2004-10-19 21:58:20 | 
| Message-ID: | 41758DFC.5020505@hyphen.it | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
i saw in bug 1201 that some got my problem
i detail it
i have a function that returns a void
CREATE OR REPLACE FUNCTION myFunction(int2, int2)
RETURNS void AS
$BODY$
	UPDATE	table 
	SET	field1 = $1 
	WHERE	field2 = $2;
$BODY$
LANGUAGE 'sql' VOLATILE;
when i execute it with a callablestatement
CallableStatement cstm = conn.prepareCall({ call myFunction(CAST(? AS INT2), CAST(? AS INT2)) });
cstm.setInt(1, aValue.getValue());
cstm.setInt(2, anotherValue.getValue());
i got the following error
org.postgresql.util.PSQLException: ERROR: function "jcpo_setallusersbyissuemessagestatus" in FROM has unsupported return type
    at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
    at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
    at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
    at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
    at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
any news about it?
i'm using PostgreSQL Database Server 8.0-beta2-dev3 on Windows and 
pgdev.307.jdbc3.jar drivers
thank you
federico
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-10-19 23:23:07 | Re: bug 1201 | 
| Previous Message | Tom Lane | 2004-10-19 21:23:43 | Re: BUG #1286: indices not used after a pg_restore |