Re: Stored Functions

Yolanda,

This functionality is only in the current development driver, it was
added since the 7.3 version of the driver. The current development
driver should run fine against a 7.3 database however.

--Barry

Yolanda Phillips wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>