1       15:47:41  SQL Execute: ORACLE - insert into XT_yzmb00 (MBID00, MBLBID, MBMC00, CZY000, PYSM00, WBSM00, YXBZ00,BZ0000,cjrq00,cjsj00) select 9683,mblbid,'11',1,'11','11','1','',to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss') from xt_yzmblb where mblbbh='00' and mbgs00='0' and symbys=1

2       15:47:41  SQL Data In: ORACLE - Rows affected = 1
3       15:47:41  SQL Execute: ORACLE - delete from xt_ypmbmx where mbid00=9683 and yplb00='1'

4       15:47:41  SQL Data In: ORACLE - Rows affected = 0
5       15:47:41  SQL Execute: ORACLE - select QZFS00 from bm_yd0000 where ypnm00=231 

6       15:47:41  SQL Execute: ORACLE - Insert into xt_ypmbmx(mbid00,yplb00,ts0000,ypnm00,yfid00,jl0000,yyzf00,xmyfmc,ypmc00,QZFS00) values(9683,'1',3,231,'117',1,'','','阿胶','2')

7       15:47:41  SQL Data In: ORACLE - Rows affected = 1
8       15:47:41  SQL Execute: ORACLE - select QZFS00 from bm_yd0000 where ypnm00=229 

9       15:47:41  SQL Execute: ORACLE - Insert into xt_ypmbmx(mbid00,yplb00,ts0000,ypnm00,yfid00,jl0000,yyzf00,xmyfmc,ypmc00,QZFS00) values(9683,'1',3,229,'117',1,'','','百部','2')

10      15:47:41  SQL Error: ORACLE - ORA-00001: 违反唯一约束条件 (SD_HOSPITAL.XT_YPMBMX_XSXH00_UQ)

11      15:47:41  SQL Data In: ORACLE - Rows affected = 0
12      15:47:41  SQL Execute: ORACLE - rollback

13      15:47:41  SQL Data In: ORACLE - Rows affected = 0
14      15:47:41  SQL Execute: ORACLE - ROLLBACK WORK