select SF_XT_GETGJYBZDByMC0000('gend','','1') as FHJG00 from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:05

select SF_XT_GETGJYBZDByMC0000('gend','','1') as FHJG00 from dual




Elapsed time: 0.007

select SF_XT_GETGJYBZDByMC0000('nat_regn_code','中国','1') as FHJG00 from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:05

select SF_XT_GETGJYBZDByMC0000('nat_regn_code','中国','1') as FHJG00 from dual




Elapsed time: 0.001

select SF_XT_GETGJYBZDByMC0000('naty','汉族','1') as FHJG00 from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:05

select SF_XT_GETGJYBZDByMC0000('naty','汉族','1') as FHJG00 from dual




Elapsed time: 0.002

select SF_XT_GETGJYBZDByMC0000('psn_cert_type','身份证','1') as FHJG00 from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:05

select SF_XT_GETGJYBZDByMC0000('psn_cert_type','身份证','1') as FHJG00 from dual




Elapsed time: 0.001

select * from XT_XS0000 where trim(DM0000) = '' 


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:05

select * from XT_XS0000 where trim(DM0000) = '' 




Elapsed time: 0.002

select SF_XT_GETGJYBZDByMC0000('mrg_stas','','1') as FHJG00 from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:05

select SF_XT_GETGJYBZDByMC0000('mrg_stas','','1') as FHJG00 from dual




Elapsed time: 0.001

select SF_XT_GETGJYBZDByMC0000('prfs','','1') as FHJG00 from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:05

select SF_XT_GETGJYBZDByMC0000('prfs','','1') as FHJG00 from dual




Elapsed time: 0.001

select SF_XT_GETGJYBZDByMC0000('patn_rlts','','1') as FHJG00 from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:05

select SF_XT_GETGJYBZDByMC0000('patn_rlts','','1') as FHJG00 from dual




Elapsed time: 0.001

BEGIN "SP_XT_CANSEQ" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0,P_FLAG00 => :P_FLAG00,P_XHLY00 => :P_XHLY00,P_COMMIT => :P_COMMIT); END;
Error occurred: [1036] (ORA-01036: illegal variable name/number
)



:1=['?
']
:2=['?
']
:3=['?
']
:4=['?
']
:5=['?
']
P_NAME00=['ZYH000']
P_VALUE0=['02160']
P_FLAG00=['0']
P_XHLY00=[0.0e+2147483647]
P_COMMIT=['Y']


Elapsed time: 3.751

select sysdate from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:09

select sysdate from dual




Elapsed time: 0.000

select sysdate from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:09

select sysdate from dual




Elapsed time: 0.001

 select a.* from VW_YS_BRZYSQ a where a.SQYXBZ ='1' and a.ZT0000<>'7' and a.BRID00 = -1.00 and SQYYID = '220007' and a.JSBZ00 = '0'  order by a.ZYSQID desc 


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:09

 select a.* from VW_YS_BRZYSQ a where a.SQYXBZ ='1' and a.ZT0000<>'7' and a.BRID00 = -1.00 and SQYYID = '220007' and a.JSBZ00 = '0'  order by a.ZYSQID desc 




Elapsed time: 0.035

select count(1) KCS000 from BM_CWK000 where BQH000 = 0 and CWZT00= '0' and KCBZ00= '1' 


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:09

select count(1) KCS000 from BM_CWK000 where BQH000 = 0 and CWZT00= '0' and KCBZ00= '1' 




Elapsed time: 0.001

BEGIN "SP_XT_CANSEQ" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0,P_FLAG00 => :P_FLAG00,P_XHLY00 => :P_XHLY00,P_COMMIT => :P_COMMIT); END;
Error occurred: [1036] (ORA-01036: illegal variable name/number
)



:1=['L?
']
:2=['L?
']
:3=['L?
']
:4=['L?
']
:5=['L?
']
P_NAME00=['ZYH000']
P_VALUE0=['02160']
P_FLAG00=['0']
P_XHLY00=[0.0e+2147483647]
P_COMMIT=['Y']


Elapsed time: 0.004

BEGIN "SP_XT_CANSEQ" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0,P_FLAG00 => :P_FLAG00,P_XHLY00 => :P_XHLY00,P_COMMIT => :P_COMMIT); END;
Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2022-08-24 11:21:11

BEGIN "SP_XT_CANSEQ" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0,P_FLAG00 => :P_FLAG00,P_XHLY00 => :P_XHLY00,P_COMMIT => :P_COMMIT); END;

Error occurred: [20001] (ORA-20001: 执行过程SP_XT_CANSEQ修改序列号时出错！*。错误代码：-1400ORA-01400: cannot insert NULL into ("SD_HOSPITAL"."XT_GETSEQ"."VALUE0")
ORA-06512: at "SD_HOSPITAL.SP_XT_CANSEQ", line 33
ORA-06512: at line 1
)