Re: Using User Defined Type in JDBC code

On Thu, 25 Mar 2004, Gunjeet Singh wrote:
> Hi,
>
> Can somone tell me how I can call a pl/pgsql stored function
> that returns a user-defined type from the JDBC code ?
>
> What type do you use while registering the out parameter for a function
> that returns a user-defined type ?
>

The easiest way to do this is not to use a CallableStatement, but a normal
Statement or PreparedStatement and issue a

SELECT * FROM string_n_refcursor();

Kris Jurka