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 语句 |