Postgres Pro
Downloads
Home   >   mailing lists

Re: need advice about out parameter settings while calling stored procedure in Java code - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: need advice about out parameter settings while calling stored procedure in Java code
Date
Msg-id mpd9rf$gh6$1@ger.gmane.org
Whole thread Raw
In response to need advice about out parameter settings while calling stored procedure in Java code  (Alex Wang <alex.wang@ebaotech.com>)
List pgsql-jdbc
Tree view 
Alex Wang schrieb am 30.07.2015 um 15:18:
> I am migrating from Oracle to Postgresql, and have encountered below
> issue while calling stored procedure via the latest PG JDBC
> (postgresql-9.4-1201.jdbc4.jar).>
>
> ----------start------------
>
> PROCEDURE p_myprocedure(a character varying, b character varying, c character varying,d character varying, OUT o1
text,OUT o2 text) IS 
>   BEGIN
> Blalabla;
> END;
> ----------end-------------
>

The above is invalid for PostgreSQL.

Are you sure you are using PostgreSQL and not EnterpriseDB? (which I think offers such a compatibility layer)

Thomas

pgsql-jdbc by date:

Previous
From: Alex Wang
Date:
Subject: need advice about out parameter settings while calling stored procedure in Java code
Next
From: Balázs Zsoldos
Date:
Subject: Why is columnNames in Connection.prepareStatement(sql, columnNames[]) automatically quoted