livebos --存储过程使用js

<%@ livebos language='javascript' %>
//ABS_Select (vname IN number,fn out VARCHAR2, vfid out number,finstid out number)--OA匹配
var ret = LB_sqlProcedure('call ABS_Select(?,:fn,:vfid{int},:finstid{int})',[3]);
LB_Logger("error",ret.get('fn')+">>>>>>>>>>>>>>");
//S_SETRETNOTE('过程返回值：'＋ret.get('retval')+'  变量name:['+ret.get('name')+']
//num:'+ret.get('num')+' 变量db:'+ret.get('db')+' 变量date:'+ret.get('date'));

 

 

 

 

CREATE OR REPLACE PROCEDURE ABS_Select (vname IN number,fn out VARCHAR2, vfid out number,finstid out number)--OA匹配
is
temp_fn varchar2(100);
temp_fid number;
temp_finstid number;
begin

select a.FForm, a.InstID,a.id into temp_fn,temp_finstid,temp_fid
 from
(
  select FForm,InstID,id from F_FM_EnterExpen where id=vname--z招待报销

)a;
fn:=temp_fn;
vfid:=temp_fid;
finstid:=temp_finstid;
end ABS_Select;