Using User Defined Type in JDBC code

Поиск
Список
Период
Сортировка
От Gunjeet Singh
Тема Using User Defined Type in JDBC code
Дата
Msg-id 200403260005.i2Q05qEe228893@jurassic.eng.sun.com
обсуждение исходный текст
Ответы Re: Using User Defined Type in JDBC code  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc

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 ?

Please see the type definition and function definition below.
The function gets created successfully but I don't know how to test them
from sql prompt or even more importantly from JDBC code.

create type gs_demotype as (
   value1 text,
   value2 text,
   value3 REFCURSOR );


create function string_n_refcursor()
returns gs_demotype
as '
   declare
    rval demotype;
    rc     REFCURSOR;
   begin
    rval.value1 := ''some string'';
    rval.value2 := ''some other string'';
    OPEN rc FOR SELECT name,location FROM cities;
    rval.value3 := rc;
    return rval;
   end;
' language 'plpgsql';

Thanks,

Gunjeet





В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Mikhail Ts
Дата:
Сообщение: JDBC3 "invalid message format" error
Следующее
От: Gunjeet Singh
Дата:
Сообщение: Using User Defined Type in JDBC code