读书人

ibatis 2.3 调用Oracle Function 回来

发布时间: 2013-04-05 10:24:33 作者: rapoo

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;

读书人网 >编程

热点推荐