function SF_XT_GETSOMENOSPSYMSTR
(
  PInStr in varchar2
)
-- MODIFICATION HISTORY
-- Person    Date        Comments
-- jlg       2018.04.21  Create 去除字符串中某些特殊符号的函数 ZYSF9-20180423-002
-- jlg       2018.05.09  要过滤的特殊字符改为从配置表XT_TSZFGL里取 ZYSF9-20180508-003
return varchar2
is
--type map is table of varchar2 (10) index by binary_integer;
--suzi_map     map;            --数字map
--  i   int            := 0;
  str varchar2(200)  := '';
  cursor cur_tszf is 
    select TSZF00 from XT_TSZFGL where SFGL00='1' order by XH0000;
begin
  str:= PInStr;
  for tszf in cur_tszf loop
      str:= replace(str,tszf.TSZF00,'');  
  end loop;
  return str;
end;