({ call a( ?, ? ) });
cs.registerOutParameter(1, Types.INTEGER);
cs.registerOutParameter(2, Types.OTHER);
cs.execute();
ResultSet rs = (ResultSet) cs.getObject(2);
...
2010/1/28 Raymond O'Donnell r...@iol.ie:
On 28/01/2010 07:32, 张海峰 wrote:
i have 2 functions, naming a and b, both outputing
i have 2 functions, naming a and b, both outputing a resultset(cursor)
and a integer.
a calls b
a:
CREATE OR REPLACE FUNCTION public.t_outer (out o_rs
pg_catalog.refcursor, out o_i integer) RETURNS record AS
...
select t_inner(o_rs, o_i);
...
b:
CREATE OR REPLACE FUNCTION public.t_inner (out