Re: proposal for CallableStatements to handle multiple out - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: proposal for CallableStatements to handle multiple out
Date
Msg-id 40D37653.8010302@opencloud.com
Whole thread Raw
In response to proposal for CallableStatements to handle multiple out parms  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: proposal for CallableStatements to handle multiple out
List pgsql-jdbc
Dave Cramer wrote:
> I'm in the process of writing a patch to get the driver to handle
> multiple out parms.
>
> One mechanism is to create a composite type and a function such as:
>
> create type Numeric_Proc_RetType as(it1 numeric(30,15),it2
> numeric(30,15),it3 numeric(30,15));");
>
> create function Numeric_Proc(numeric(30,15),numeric(30,15),
> numeric(30,15)) returns Numeric_Proc_RetType as 'declare work_ret
> record; begin select * into work_ret from Numeric_Tab; return work_ret;
> end;' language 'plpgsql';
>
>
> Are there any problems with this ?

Could you describe the driver side of your proposal?

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Prepare Statement
Next
From: Oliver Jowett
Date:
Subject: Re: [PATCHES] Nested transactions