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

proposal for CallableStatements to handle multiple out parms

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: proposal for CallableStatements to handle multiple out parms
Date: 2004-06-18 18:13:39
Message-ID: 1087582419.15586.173.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-jdbc
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 ?

Dave
-- 
Dave Cramer
519 939 0336
ICQ # 14675561


Responses

pgsql-jdbc by date

Next:From: li liDate: 2004-06-18 18:29:07
Subject: unsubscribe
Previous:From: amo99@libero.itDate: 2004-06-18 18:00:07
Subject: Pg 7.4.2, jdbc 7.4, data type inet

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