Am 15.08.2015 um 11:08 schrieb Thomas Hill:
> Hi,
>
> I have installed pl/Java and am struggling to understand how the code
> in the calling Java program needs to look like if I want to use the
> resultsethandle interface and just call the sample function listsupers.
> Calling listsupers from pgAdmin (select rte.listsupers() in my
> environment) works fine and returns two rows.
>
> I tried
> CallableStatement cstmt = null;
> try {
> cstmt = conn.prepareCall("{ ? = CALL
> \"rte\".\"listsupers\"() }");
> cstmt.executeUpdate();
>
> ResultSet rs = cstmt.getResultSet();
> while (rs.next()){
> rs.getString(1);
> }
>
> but this is throwning an error when the executeUpdate() is called.
>
> Can someone please help?
>
> Thanks
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at lists.pgfoundry.org
> http://lists.pgfoundry.org/mailman/listinfo/pljava-dev
Note: The sample code getNames for the resultsetprovider interface works
fine. The error thrown when trying to run the above listsupers sample is
"Malformed function or procedure escape syntax at offset 2." but
listsupers dowsn't have any in out our parameters!?