Re: Problem about executeUpdate and stored procedure that

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. But the 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 returns a row. But I do need to call a function that returns no result, but do some updates. I defined the function as "create function ... 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(at)vip(dot)sina(dot)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(at)postgresql(dot)org)
>