一则> ORA-00933: SQL command not properly ended 排查解决

SQL中正常执行的SQL语句：

update b_dispatch set ReferenceNum = (
  case when ISNULL(fno,' ')=' ' then fno when fno='〔〕' then '' else replace(k.FileNo, '%s', fno) end 
)  from b_dispatch b 
left join k_docimage k on b.ModName = k.Name  
where b.ID = '{4589EEC4-9E7F-4CBF-947E-8D47FDE325AC}' and (fno<>ReferenceNum);

在ORALCE中这样会报错：ORA-00933: SQL command not properly ended

--> ORA-00933: SQL command not properly ended
update b_dispatch set ReferenceNum = (
  case when NVL(fno,' ')=' ' then fno when fno='〔〕' then '' else replace(k.FileNo, '%s', fno) end 
)  from b_dispatch b
left join k_docimage k on b.ModName = k.Name  
where b.ID = '{4589EEC4-9E7F-4CBF-947E-8D47FDE325AC}' and (fno<>Refe