One more: Function does not exist error - Mailing list pgsql-jdbc

Hi,

I am using jdbc to talk to a PostgresQL 8.0 database. I am using the
same driver as provided in the jdbc directory of the installation.
Here's my function definition.

CREATE OR REPLACE FUNCTION "public"."updatevaluesfordataset" (text,
text, text, text, text) RETURNS integer AS
$body$
/* New function body */

DECLARE
       datasetid ALIAS FOR $1;
       valuesString ALIAS FOR $2;
       delimited ALIAS FOR $3;
       colStart ALIAS FOR $4;
       totColumns ALIAS FOR $5;
       column_values text[];
       LB1 integer;
       UB1 integer;
       updateStatement text;

BEGIN
     column_values := string_to_array(valuesString, '\b');

     IF totColumns == 1 THEN
        LB1 := array_lower(column_values, 1);
        UB1 := array_upper(column_values, 1);

       FOR i IN LB1..UB1 LOOP
           updateStatement := "UPDATE ds_data SET col"
                           || qoute_literal(colStart)
                           || " = '"
                           || quote_literal(column_values[i])
                           || " WHERE datasetid ="
                           || quote_literal(datasetid)
                           || " \"rowNo\" ="
                           || quote_literal(i)

            EXECUTE updateStatement;

        END LOOP;
     ELSE

     END IF;

     RETURN 1;
END;
$body$
LANGUAGE 'plpgsql' VOLATILE RETURNS NULL ON NULL INPUT SECURITY INVOKER;



And my java code that is supposed to call it.

Class.forName("org.postgresql.Driver");
Connection conn =
DriverManager.getConnection("jdbc:postgresql://localhost/cce_new_ds","us
er","");

CallableStatement cs = conn.prepareCall("{? = call
updatevaluesfordataset(?,?,?,?,?)}");
cs.registerOutParameter(1, Types.INTEGER);

cs.setString(2, "1080");
cs.setString(3, "2");
cs.setString(4, "FirstValue");
cs.setString(5, "1080");
cs.setString(6, "1080");

cs.execute();
cs.close();

conn.close();


However on running this java code, I get an error saying

java.sql.SQLException: ERROR: function updatevaluesfordataset(character
varying, character varying, character varying, character varying,
character varying) does not exist
    at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1365)
    at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1160)
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
172)
    ....

I tried changing my parameters to varchar as well and it still would
give me the same error. Any ideas?

The other unrelated thing is that it was a little unintuitive to me as
to how to create a stored procedure rather than a function? I do not
want to return any value while executing these updates. Is there a way?
I am sure there would be one, I just haven 't been able to figure it
out.


Thanks a bunch,
Anuj