Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.1.6_4.1.7_oracle.sql
===================================================================
diff -u -r13507 -r13510
--- ssts-web/src/main/webapp/dataUpdater/sqls/4.1.6_4.1.7_oracle.sql	(.../4.1.6_4.1.7_oracle.sql)	(revision 13507)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/4.1.6_4.1.7_oracle.sql	(.../4.1.6_4.1.7_oracle.sql)	(revision 13510)
@@ -1,12 +1,13 @@
-update GoodPurchaseItem set disposableGoodsId = (select id from DisposableGoods where GoodPurchaseItem.name= case when specification is null then name else name || '['|| specification ||']' end)
-where disposableGoodsId is null;
+execute immediate 'update GoodPurchaseItem set disposableGoodsId = (select id from DisposableGoods where GoodPurchaseItem.name= case when specification is null then name else name || ''[''|| specification ||'']'' end)
+where disposableGoodsId is null';
 
-update GoodPurchaseItem set materialDefinitionId = (select id from MaterialDefinition where GoodPurchaseItem.name= case when specification is null then name else name || '['|| specification ||']' end)
-where materialDefinitionId is null;
+execute immediate 'update GoodPurchaseItem set materialDefinitionId = (select id from MaterialDefinition where GoodPurchaseItem.name= case when specification is null then name else name || ''[''|| specification ||'']'' end)
+where materialDefinitionId is null';
 
-update TousseDefinition set ancestorID=id where tousseType in ('器械包','敷料包') and ancestorID is null;
-update TousseDefinition set ancestorID=id where tousseType in ('消毒物品') and forDisplay='1' and ancestorID is null;
-
-create table temp as select id , name from TousseDefinition where tousseType in ('消毒物品') and forDisplay='1';
-update TousseDefinition set ancestorID=(select id from temp where name=TousseDefinition.name) where tousseType in ('消毒物品') and forDisplay='0' and ancestorID is null;
-drop table temp;
\ No newline at end of file
+execute immediate 'update TousseDefinition set ancestorID=id where tousseType in (''器械包'',''敷料包'') and ancestorID is null';
+execute immediate 'update TousseDefinition set ancestorID=id where tousseType in (''消毒物品'') and forDisplay=''1'' and ancestorID is null';
+execute immediate 'commit';
+execute immediate 'create table temp as select id , name from TousseDefinition where tousseType in (''消毒物品'') and forDisplay=''1''';
+execute immediate 'update TousseDefinition set ancestorID=(select id from temp where name=TousseDefinition.name) where tousseType in (''消毒物品'') and forDisplay=''0'' and ancestorID is null';
+execute immediate 'commit';
+execute immediate 'drop table temp';
\ No newline at end of file