ibatis 2.3 调用Oracle Function 回来字符串实例

ibatis 2.3 调用Oracle Function 返回字符串实例

CREATE OR REPLACE Function F_createalarminfoinstancename(                                                          v_instancename in varchar2 ,                                                          v_almobjtype in varchar2,                                                          v_almobj in varchar2                                                          ) return  varchar2isv_err varchar2(200);result varchar2(10);Begin  result:='1';       update alm_alarminfo set instancename = v_instancename where alarmobjdn = v_almobj and alarmobjtype = v_almobjtype;       commit;      return result;End F_createalarminfoinstancename;