var pro_sql="SQL(\"hxns\",\"call update_family_print('"+familyNo+"')\",1,1)";
FR.remoteEvaluate(pro_sql);
create or replace procedure UPDATE_FAMILY_PRINT(familyNo in varchar2) as
v_print number(2);
begin
select print into v_print from hxns_family where family_no = familyNo;
if (v_print is null) then
update hxns_family set print = 1 where family_no = familyNo;
commit;
else
update hxns_family set print = print + 1 where family_no = familyNo;
commit;
end if;
end UPDATE_FAMILY_PRINT;
这里调用FR.remoteEvaluate(pro_sql);
执行成功了,但是有警告
警告:Caused By:ORA-00900: 无效 SQL 语句