From: | Barry Lind <blind(at)xythos(dot)com> |
---|---|
To: | Han <zhouhanok(at)vip(dot)sina(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Problem about executeUpdate and stored procedure that |
Date: | 2003-05-16 17:25:23 |
Message-ID: | 3EC51F03.8070201@xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Doug Kearns | 2003-05-18 13:23:41 | [Bug] ResultSet#getMetaData() returns null |
Previous Message | Alessandro Pellegrini | 2003-05-16 15:54:08 | Blob column |