Re: Calling functions with table-based-type parametars

[Kris Jurka <books(at)ejurka(dot)com>]

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