On Mon, 26 Feb 2007, Mario Splivalo wrote:
>> Why not conn.prepareCall("{call f1(ROW(?, ?)}") or
>> conn.prepareStatement("SELECT f1(ROW(?, ?))");
>
> When I try it like above (using conn.prepaleCall), i get this:
>
> 2007-02-26 16:58:19.004 CET [9592] <jura> SELECTERROR: function
> f1(record) does not exist
> 2007-02-26 16:58:19.004 CET [9592] <jura> SELECTHINT: No function
> matches the given name and argument types. You may need to add explicit
> type casts.
This is saying you need to write it with a cast from the row to the table
type:
conn.prepareCall("{call f1(ROW(?, ?)::t1)}")
Kris Jurka