Problem about executeUpdate and stored procedure that returns nothing

Поиск
Список
Период
Сортировка
От Han
Тема Problem about executeUpdate and stored procedure that returns nothing
Дата
Msg-id 20030516065046.41FE2476957@postgresql.org
обсуждение исходный текст
Ответы Re: Problem about executeUpdate and stored procedure that  (Barry Lind <blind@xythos.com>)
Список pgsql-jdbc
pgsql-jdbc

    When using executeUpdate with {call func_name(?,?,?)}, there's an error saying that no result should be returned.
Butthe value is updated successfully in the database by the function. 
    I know that it's because {call func_name(?,?,?)} be transfered to "select func_name(...) as result" and this sql
returnsa row. But I do need to call a function that returns no result, but do some updates. I defined the function as
"createfunction ... returns void as'...'". But it still returns a row contains one field with null value. 
    I don't want to use executeQuery. Is there anyother way to do this? Or should the jdbc executeUpdate should be
fixed?
    Thanks!

        


        Han
        zhouhanok@vip.sina.com
          2003-05-16




В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Peter Royal
Дата:
Сообщение: [PATCH] Fix COLUMN_SIZE and NUM_PREC_RADIX in metadata
Следующее
От: Alessandro Pellegrini
Дата:
Сообщение: Blob column