jdbc - USe CallableStatement for Oracle Functions with ROWTYPE Parameters -

to call oracle procedure rowtype parameter i've got solution. problem functions. in case of procedures build string pl/sql script fill rowtype fields , call procedure:

declare     r_tmp test_table%rowtype;   begin      r_tmp.id := ?;     r_tmp.yfe_id := ?;     r_tmp.kz := ?;      pck_test.test(r_tmp);   end; 

this generated string used create callablestetment setint, setstring fields filled content before procedure called.

with this, working fine. problems functions rowtype. have no idea handle return value. functions normal parameters no problem code this

preparecall("{ ? = call pck_test.func_test(?,?) }"); 

but need filled rowtype parameter.

any ideas?

sorry bad english , reading.

i'm not able test @ moment looks want have anonymous block generated as:

declare     r_tmp test_table%rowtype;  begin      r_tmp.id := ?;     r_tmp.yfe_id := ?;     r_tmp.kz := ?;      ? := pck_test.test(r_tmp); end; 

and call same way did procedure call; set first 3 bind variables setint() etc., register fourth output parameter, , retrieve result getint(4).