1 15:40:47 Log started for: LED显示系统 2 15:40:47 SQL Prepare: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 15:40:47 SQL Transact: ORACLE - Set autocommit on/off 4 15:40:47 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 5 15:40:47 SQL Stmt: ORACLE - Fetch 6 15:40:47 SQL Data Out: ORACLE - Column = 1, Name = RQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170531 7 15:40:47 SQL Data Out: ORACLE - Column = 2, Name = SJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:46:01 8 15:40:47 SQL Data Out: ORACLE - Column = 3, Name = SID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 301.000000 9 15:40:47 SQL Data Out: ORACLE - Column = 4, Name = SERIAL#, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 48215.000000 10 15:40:47 SQL Stmt: ORACLE - Reset 11 15:40:47 SQL Stmt: ORACLE - Close 12 15:40:47 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.21.36','Z',trim(PROGRAM)||'+'||'显示系统',SID,serial# ,'20170531','15:46:01','scott@0:C0324AED7E799E98058027B34CD8ED15' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 13 15:40:47 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.21.36','Z',trim(PROGRAM)||'+'||'显示系统',SID,serial# ,'20170531','15:46:01','scott@0:C0324AED7E799E98058027B34CD8ED15' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 14 15:40:47 SQL Data In: ORACLE - Rows affected = 1 15 15:40:47 SQL Stmt: ORACLE - Close 16 15:40:47 SQL Prepare: ORACLE - Commit 17 15:40:47 SQL Execute: ORACLE - Commit 18 15:40:47 SQL Data In: ORACLE - Rows affected = 0 19 15:40:47 SQL Stmt: ORACLE - Close 20 15:40:47 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 21 15:40:47 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 22 15:40:47 SQL Stmt: ORACLE - Fetch 23 15:40:47 SQL Data Out: ORACLE - Column = 1, Name = SJKMM0, Type = fldZSTRING, Precision = 40, Scale = 0, Data = ipjJSKqhCbW24Xoi 24 15:40:47 SQL Data Out: ORACLE - Column = 2, Name = SJKKL0, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 835AC1088BD07479====D6A6CA84C402AD04B67C8746E6F888F0++++ 25 15:40:47 SQL Stmt: ORACLE - Reset 26 15:40:47 SQL Stmt: ORACLE - Close 27 15:40:47 SQL Connect: ORACLE - Disconnect GENERAL 28 15:40:47 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221218' 29 15:40:47 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221218' 30 15:40:47 SQL Stmt: ORACLE - Fetch 31 15:40:47 SQL Data Out: ORACLE - Column = 1, Name = YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 221218 32 15:40:47 SQL Stmt: ORACLE - Reset 33 15:40:47 SQL Stmt: ORACLE - Close 34 15:40:47 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.21.36','Z',trim(PROGRAM)||'+'||'显示系统',SID,serial# ,'20170531','15:46:01','sd_hospital@0:0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 35 15:40:47 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.21.36','Z',trim(PROGRAM)||'+'||'显示系统',SID,serial# ,'20170531','15:46:01','sd_hospital@0:0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 36 15:40:47 SQL Data In: ORACLE - Rows affected = 1 37 15:40:47 SQL Stmt: ORACLE - Close 38 15:40:47 SQL Prepare: ORACLE - Commit 39 15:40:47 SQL Execute: ORACLE - Commit 40 15:40:48 SQL Data In: ORACLE - Rows affected = 0 41 15:40:48 SQL Stmt: ORACLE - Close 42 15:40:48 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 43 15:40:48 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 44 15:40:48 SQL Stmt: ORACLE - Fetch 45 15:40:48 SQL Data Out: ORACLE - Column = 1, Name = DLFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 46 15:40:48 SQL Data Out: ORACLE - Column = 2, Name = MMXSF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 47 15:40:48 SQL Stmt: ORACLE - Reset 48 15:40:48 SQL Stmt: ORACLE - Close 49 15:40:58 SQL Prepare: ORACLE - select nvl(rtrim(sf_xspxs_led(1)),'') XSPXS0 from dual 50 15:40:58 SQL Execute: ORACLE - select nvl(rtrim(sf_xspxs_led(1)),'') XSPXS0 from dual 51 15:40:59 SQL Blob IO: ORACLE - Return blob data 52 15:40:59 SQL Stmt: ORACLE - Fetch 53 15:40:59 SQL Stmt: ORACLE - Reset 54 15:40:59 SQL Stmt: ORACLE - Close