Re: need advice about out parameter settings while calling stored procedure in Java code

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: need advice about out parameter settings while calling stored procedure in Java code
Дата
Msg-id mpd9rf$gh6$1@ger.gmane.org
обсуждение исходный текст
Ответ на need advice about out parameter settings while calling stored procedure in Java code  (Alex Wang <alex.wang@ebaotech.com>)
Список pgsql-jdbc
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Alex Wang
Дата:
Сообщение: need advice about out parameter settings while calling stored procedure in Java code
Следующее
От: Balázs Zsoldos
Дата:
Сообщение: Why is columnNames in Connection.prepareStatement(sql, columnNames[]) automatically quoted