Stored Functions

Good day,

I urgently need help!!

I've just upgraded to postgresql-7.3.4. Using pg73jdbc3.jar driver. This is
because I really need to use stored functions.

This is the plpgsql function:

CREATE OR REPLACE FUNCTION LoadGlobals(INT) RETURNS refcursor AS '
DECLARE
v_global_id ALIAS FOR $1;
ref refcursor;
BEGIN

OPEN ref FOR
SELECT global_values_desc, section_title, menu_url, include_file_url
FROM GLOBAL_VALUES
WHERE global_values_id = v_global_id;
--IF NOT FOUND THEN --If nothing was returned in the last query
--RAISE EXCEPTION ''Invalid global id.'';
--ELSE
RETURN ref;
--END IF;

END;
' LANGUAGE 'plpgsql';

The JDBC code:

private static final String driver = "org.postgresql.Driver";
private static final String user = "someuser";
private static final String pass = "password";
private static final String dbURL =
"jdbc:postgresql://10.123.0.00/somedb";

conn.setAutoCommit(false);
CallableStatement proc = conn.prepareCall("{? = call LoadGlobals (?) }");
proc.registerOutParameter(1, Types.OTHER);
proc.setInt(2, sectionId);
proc.execute();
results = (ResultSet)proc.getObject(1);
System.out.println("ResultSet: " + results);

...

I get the following error:
SQL Exception: No class found for refcursor

Any suggestions?

Sincerely,

Yolanda Phillips
Web Applications Developer