parameters :CWID00=45436 :UserId=1913 :UserName=测试库 :ErrorMessage=ORA-20003: ORA-20003: (卡文)脂肪乳氨基酸17葡萄糖11%注射液不能为长嘱!
 :ErrorObject=System.Data.OracleClient :ErrorStack=   在 System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   在 System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   在 System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
   在 System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
   在 Medical.Common.Data.OracleDataAccess.ExecuteNoneQuery(String queryString) :ErrorMethod=CheckError :Remark=ExecuteNoneQuery :CWTPMC= :CWSQL0=DECLARE c_yzid number;as_YHMSG0 varchar(4000);as_SYSMSG varchar(4000);c number;t number;V_RETURN number;zrzc number;t_yzid number; BEGIN SP_ZS_YPYZ00_ZYDZBL(0,c_yzid,888930,'','0','0','0','10:49:22',1913,'测试库','20211231','10:49:05',1,1,0,2,'005','',0,'',null,0,0,1009,'20220101',497,'','0','','','',''); SP_BQ_YPYZMX_ZYDZBL(0,c_yzid,null,8122,'(基)(高危)(卡文)脂肪乳氨基酸17葡萄糖11%注射液','1','',1440,1,'','1','正常','',1,2,'0','0',1,0,0,0,'','','ml',1,'袋',1440,null,''); SP_BQ_YPFJFY_ZYDZBL(c_yzid,1913); SP_ZS_YJTSXZ_ZYDZBL(888930,0,V_RETURN,as_SYSMSG,1);if V_RETURN > 1 then raise_application_error(-20003, as_SYSMSG);end if; update BQ_YPYZ00 t set t.blbz00='N',t.yzlx00=0,t.sfps00='0',t.pspc00='' where t.yzid00=c_yzid;select count(*) into c from VW_ZY_LJZRZC_ZYDZBL where ZYID00='888930' and JSFS00 = '执行中';if c > 0 then select zrzcid into zrzc from VW_ZY_LJZRZC_ZYDZBL where ZYID00='888930' and JSFS00 = '执行中';select count(*) into t from VW_ZS_LJJHYZXX_ZYDZBL where zyid00=888930 and  DQJDBZ='1' and KSRQ00<=to_char(sysdate, 'YYYYMMDD' ) and zrzcid=zrzc and ypnm00=8122;if t = 0 then SP_ZY_LJ_YZADDTOLJYZ_DT_ZYDZBL(888930,c_yzid,0,as_YHMSG0,as_SYSMSG);else SP_ZY_LJ_YZRELATETOLJYZ_ZYDZBL(888930,c_yzid,0,as_YHMSG0,as_SYSMSG);end if;end if;COMMIT; EXCEPTION WHEN OTHERS THEN ROLLBACK; RAISE_APPLICATION_ERROR(sqlcode, sqlerrm); END;