("{ 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 :
> On 28/01/2010 07:32, 张海峰 wrote:
>> i have 2 functions, naming a and b, bo
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_inne
