Thread: Problem about executeUpdate and stored procedure that returns nothing

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




Re: Problem about executeUpdate and stored procedure that

From
Barry Lind
Date:
Han,

Could you send a more complete test case, that I could compile and run?

thanks,
--Barry


Han wrote:
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>