Skip site navigation (1) Skip section navigation (2)

Re: proposal for CallableStatements to handle multiple out

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: pg(at)fastcrypt(dot)com
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: proposal for CallableStatements to handle multiple out
Date: 2004-06-18 23:10:11
Message-ID: 40D37653.8010302@opencloud.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2004-06-18 23:30:49
Subject: Re: [PATCHES] Nested transactions
Previous:From: Oliver JowettDate: 2004-06-18 23:07:03
Subject: Re: Prepare Statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group